How do I setup a date field property that allows only Saturdays?

For example: 03/13/2010 would be fine, as that is a Saturday. 03/12/2010 would return an error message as it is a Friday. How would I create a field property for this, or would I use a different aspect of Access creation?

UNLOCK A SECURED CODE MODULE

Hi All. I need to send a "patch" to a remote user to replace a form in an Access 2007 application. The code behind the forms of that database has been locked with a password. In order to copy the new form into the place of the previous one I first need to unlock the code, copy the form and then relock the code. Everything is quite simple except I cannot get the code to unlock from the "patch" application. The password is known to me. Any pointers will be appreciated. -- Kepior Senso Fumor

sync combox boxes

I have seen this question for older versions and for use on forms, let me throw my twist into this. I have a table called student list with lname, first name, grade, student id. I have a second table that records student parking stickers and parking violations called action list. there are linked by a one to many relationship by student id. I created a simple form from studnet list that shows the fields for the action file table below it. My use will enter data directly to the fiedls there not thru a form. (he likes that). My question when I ge to the filed make I would like t

Help - is this possible?

So - This is what I am trying to achieve: In our business, our orders are made up of products (pizzas actually!) to which the customer can add or remove toppings. Adding a topping costs $1.00. My AddAnOrderandDetailsform captures the customer. My OrderDetailsSubform captures the products (S Margherita, for example), the unit price, quantity, and extended price (yes calculated by multiplying Quantity ad UnitPrice). I then have my ItemDetailsSubform which I want to capture the additional toppings or toppings removed, eg + Pepperoni or - Pepperoni. Both my OrderDetailsSub

Changing Template Design

I am using the personal ledger template. I want the "Actual Amount" section to show a running total per row. I don't just want the grand total at the bottom. That way I can see how each transaction affects my account so I can compare to my bank account. How can I change the function of this or add another box to this? -- Thanks

design access

Hello everyone, I have a table tblOrders CustomerName DateOrder RefNo Amount Status primary key: RefNo Field type: Status - check box I have a table tblPayments CustName Datepaid PaidRef AmntPaid primary key: PaidRef can anyone help me figure out how can I design my query and my form/subform that when in my tblPayment field name AmntPaid equals to tblOrder field name Amount, access will automaitcally set the field name Status to Yes. please can anyone help me. thanks in advance, i appreciate

Importing data from multiple sources

I need to import data of members from two different sources, and then compare the data. Is there an easy way of doing this? -- Ted in Chicago

Data Rules Violations

I have a table of 19,000 records with about 225 fields in each record. It is not an indexed table, just a table of educational transactions. Some how when I go to update the historical table seven (7) records have gotten some bad info in them. I know I can copy the table to another database and look at them one field at a time, but this will take forever. Does anyone know a quick method of finding the seven bad records? Thanks in Advance John Q

Access Services?? Accessing DB from web??

Could someone explain to be the workflow/possibilities of Sharepoint or other Access services? Please forgive me, in advance, if I do not get all my terminology right on this subject. I continue to read things about Sharepoint and Access Services that hint at what I would like to do, but I don't quite understand what they do or how they intergrate into Acess or if they will for sure be a solution. Do any of these services make it possible for users to access a database from the the internet? If not is there a way to do this without building a php or asp based website to acc

Keeping data private per User in a multi user database

Hello. I have an Accounting Access DB that I intend at some point to split into front-end (tables, forms, reports) and back-end (data), then I hope to deploy on the web. I will eventually have around 30 distributed users (only about 5 concurrent) – each inputs the same type of financial data but does business independent of the others and so must NEVER see the data entered by the other users. To make future releases and bug fixes as simple as possible, I intend to have a single instance of the front-end that each of the Users will access. However, as each User must NEVER see

Thanks to Allen Browne... and all MVPs.....

Thanks you very much... for reply and thoughts.. convayed.. will look site and read again million thanks.. Dr. Khalak

Relational Database Layout

What I would like to do is create a database to track sales, customer info and customer demographics using 3 separate tables: Customer Info(name, address, phone, etc.), Sale info(what was purchased, date, size, etc), and Demographics(Gender, age, income, etc). I have the three tables populated with the needed fields but I'm having a problem creating the relationship setup so that I can say look up a customer or product and see what product that customer purchased or select a product and see which customers have purchased it. This is a beginner question, which I am, but w

Creating new row in other table

Dear All, Please teach me, how to make a new row/list in other table by entering number in other table. Sample, In the table A and in the field "Details", I put the number 2 and it automatically creates two rows in table B. Can this be done in MS Access? Thank you for your help. Regards, Maulwy

unique record numbers

I am trying to create a unique PIN for members in a table (not the primary key) that will be 4 digits long, and would like each new entry to be incremental. I am very new, and would appreciate a detailed instruction (though I can get around access fair enough). Any help would be appreciated.

Form Design

I feel fairly confident that I have my tables and relationships decently set. My problem now is how to display it for my staff to work with. I need some help with form layout Here's my scoop. I am re-building a camp database that was laid out on one entire table!!! So many fields... So many empty fields too. Nonetheless, we are moving onward and here is what I have... I have a camp database that has the following tables now: tblcamperinfo demographic info that may change (primary table) tblparentinfo info on parents and addresses could be more than one tblcmprcntyr d

Intermittent locking problem

Using Access 2003. I have two applications each with their own FE's and BE's and using .MDE's for user FE's. Each .MDB file is set to "Share", "No Locks" and "record-level" locking. Each app (FE and BE) is located in a separate directory with full directory access for users of the specific app. So not all users of app #1 have full directory access to app #2 and vice versa. App #2 has a comboBox that gets its recordsource using a query based on a linked table to App #1's BE. Usually the comboBox in App #2 is populated and works. But occaisonally when users are in App #1, a

Player availability list

I am trying to record players availability for team matches throughout a season. For example I have say a possible total of 50 players and there are say 40 matches throughout the season. So far about 30 players have advised me for which of the 40 matches they are available. I wish to record this availability in Access and then to be able to advise the match manager of the various games which players are available for the match for which he is responsible. I have so far created one table of matches - recording date of fixture, opposition, venue, match manager and a second table o

Set Mytable = MyDB.OpenRecordset

Help, I am not much of a programmer, but I have managed to build a fairly good tool. The original code was written in 2003 but upon the conversion to 2007, I get a Type Mismatch on the following code. Const ProductTable = "Products" Dim MyTable As Recordset Dim MyDB As Database Dim PNHolder As String Set MyDB = CurrentDb() Set MyTable = MyDB.OpenRecordset(ProductTable) ---�<<< Error appears here??

What does "tlkp" mean?

There's a "standarized" naming convention used in the design of a database...tbl, qry, rpt, etc. When I d/l a 2007 template, it uses the prefix "tlkp". It's a table. What is meant by this? Thanks.

Renewing member database design question.

Hi, 1. Background: I have a member database for a local community club. I’m in the process of adding membership renewal processing to the module. There are two types of membership; Life Time and Annual. The Life members pay a one time fee and are members for life. The Annual members pay a membership fee once a year. The renewal drive starts in November. In October, when we print the November newsletter, we include a reminder notice in the monthly news letter that is mailed each member. Members will then pay their renewal by either check or cash. I want to star

Switchboard buttons not creating

I am using Access 2007. When I add a button it does not appear on the switchboard. I did delete one button, but it was not working either. How do I create a button that will appear and work properly? Thanks in advance for your advice.

header full line but page 2 rows

Hi I like to design a report header and page over the full width of A4 paper. But all the data in 2 coloums.

Selective database splitting

Is there a way to select the specific tables you want to split for sharing across a network while other tables will remain local to each users system? I specifically want to keep a version control table local to the system rather than having it split with the other tables.

Church Database

Trying to put together a simple database for our church directory and records. We need contact info as well as DOB and group involvement etc. Make directories, labels, email groups and basic reports. Which I had no problems with. What I am having issues with is the family relationship thing. We often need to do mailings per household as well as individuals. What is the best way to "group" my families. And how should they be entered? I thought making a check box to designate a "head of household" and when entering choose a family. Or have a seperate form for "families" THEN e

Training database

Is there any way to put this into plain english I am much better at visual instruction, I to am trying to build a training data base that can generate reports of who has been trained and be able to assign certain training modules to certain job functions. Here is what I want. 1. A list of employees, what location they work at, what they have been trained on, what they still need to be trained on, who trained them, when they were trained, and when they are due to be retrained. It would be nice to be able to have several employees enrolled in every class. I have tables set up as follows

Append Query and Autonumbering

Using Access 2007; have 2 student db last year and this year, using autonumber as identifier. when i append old student to new db so that they keep old number; it causes the new db to change the autonumber when i add a new record to the 1 plus the old number instead of using new new numbers; did not have this problem in access 2003. when i appended records it put the record in and kept old number and then when i added a new record, it gave them next number.

Remote control of tabls

I have a database tables on the back end and multiple versions of front end users. Is there a way to access the table from a remote location though the internet or upload the tables to the internet and have the front end access the information in a way that the updated tables will be available to all? Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201002/1

Efficient Table Design Questions

I'm working on a Project Manager DBase for our engineering department. One of the things they want to be able to record within each project is the Size, Length and Material of the pipes installed. They also want to be able to run reports that would provide them totals based upon region, year, etc. So I'm looking at sizes ranging from 1/2" to 48" (approx 20 different sizes) plus a wide range of possible materials for each size. Question 1: Since a project could have multiple materials of the same pipe size installed, do I create a field for each possible size & material combi

Access table data type selections

When creating a new database table I am not given an option for attachments in the drop down menu. Anyone know why and how I can correct it? I get the usuals "text, memo, date, number OLE object..." but no option for attachments????

Slow form, again

Okay I'm back again, with the same problem, and at a loss. This is my 2nd database, and same brick wall! The loading of my form takes upwards of 40 seconds to load. I've gone through steps offered at previous posts (http://www.granite.ab.ca/access/performancefaq.htm). I even downloaded a template database (sales pipeline) from Microsoft and once split it slowed down dramatically as well...takes a solid minute to load their form. Could that suggest that my database design is solely not the problem and perhaps the network doesn't help? Details of my database: My form p

ORGANIZATIONAL CHART

Hi All Anybody know of software that will use Access Database as data source that will show an organizational hierachy similar to that shown in Word 2007 SmartArt? -- Kepior Senso Fumor

Dance Classes

Hi, I posted a couple of weeks ago regarding a simple DB for dance classes and received excellent advice. I�ve made good progress but have another question. I�ve been reading a lot and understand the tables are the most important part and would really appreciate help again. I want to record class payments and also bank deposits. All payments are deposits but not all deposits are class payments. Some deposits are for other various items and I can�t figure out how to relate the deposits to the class payments. I normally hand write deposit slips then I have to post checks for cla

marvendas@gmail.com Kit completo de Solenoides ( solenoid ) + chicote Para Cambio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 32239

Contato: marvendas@gmail.com marvendas @ gmail.com marvendas no gmail.com Kit completo de solenoides para Volkswagem e Audi. O kit contem: 5 solenoides 2 Epc ( solenoides de pressao ) 1 Chicote Serve para qualquer modelo VW ou Audi fabricados de 1995 ate hoje com o cambio automatico de 4 marchas � 01M Pre�o: R$ 1900.00 Temos outras tipos de solenoides e artigos importados, nao deixe de fazer uma consulta antes de comprar! Audi a3 automatico Audi a3 1.8 t automatico Audi a3 1.8 turbo automatico VW Golf gti automatico VW Golf 2.0 automatico VW Golf 1.8 turbo auto

Primary and Foreign Keys

It's the end of the day and I'm second-guessing myself and need some clarification regarding Primary and Secondary Keys and which tables they should be in. In a one-to-many relationship, the primary key is on the "one" side and the foreign key is on the "many" side, right? I.e. an Individual can have many phone numbers. tblIndividual IndID (PK) FirstName LastName tblPhone PhoneID (PK) PhIndID (FK) phonenumber phonetype What about in a one-to-one relationship? Does it really matter which the foreign key goes in? Is there an acceptable/preferred practice? I have

Tab Order for Multiple Entry Form. Vertical not horizontal tabbin

Hi there, Does anyone know how to make the tab order go vertically along columns in a multiple entry form? It seems like that tabs will always goes along a row, so you have to tab through every field in a row before it will tab to the next row. I have already tried to do this through the tab order button in the arrange tab, but it doesn't help.

Field format

I need to have a project number that forces ensures that the field has 5 parts: 1. Always the letter C 2. Last two years of Year 3. 3 digit number (sequential) 4. "-" 5.2 digit sequential (usually just 00) So the first Project in 2010 will be : C10000-00, 2nd will be C10001-00, 3rd C10002-00 and so on How do I enforce this in the field - both in the table and in the form... Thanks! -- Message posted via http://www.accessmonster.com

Calculating percentage from eneterd values within a table/form

Within my database I have a table where I will enter the fresh weight of an object in one field and the thawed weight of the object in another field. I then wish access to calculate the percentage weight loss by : (Fresh Weight-Thawed Weight)/Fresh Weight*100 I have attempted to do this as a default value of a field during the design of a table, but as data has not been entered into the weight fields access gets confused and won't allow this. Is there a way to do this without creating a query or doing it within a form? If I have to create a query or do it within the form, is the

Access 97 won't save changes to form design view.

I make changes in design view but they will not save. If I close the program, it asks me if I want to save but clicking yes does nothing. The program will not close until I click no. This is a data base made in Access 95 that has been converted to 97 file extension. The database works fine as far as entering and finding data. Of course, the help files are of no use... Thanks in advance for any help. Bill

Access 2007 Table Issue

I have developed a investment input form with look-up lists to restrict the types of data to be entered. The look-up lists come from subtables in the database. When new records are saved the data is stored in a master table which I then use to run Reports, Pivot Charts, Queries etc. However, I'm finding that the master data table is in the same look-up list format as the subtables that are used to populate the form. In other words, the master data table has drop down choices for each record. I'm finding that when I try to run a report the investment information is lost.

Part and Product Database Help

I need help designing a database for parts and products. I'll give you a brief description of the scenario: There are thousands of parts, and hundreds of products. I want a database that has the following: -a list of the parts - with description, product number, color, length, etc. -a list of the products with the associated parts included in the product -If I change a description of a part, I want it to change in the products and all related aspects I know I need a part table, but I don't know how to incorporate the products - because the parts can be used

A REAL CHALLANGE

I need to (from within Access) 1. Open a document scanning software so that a document can be scanned; and then, after scanning, record the file name of the scanned document in a database without having to enter the file name by typing it. (The scanning software automatically enters a file name for the document in the "save as" dialogue box) As I see it the created file name needs to be copied to the clipboard when the document is saved; and then pasted to the correct field in the Access database. Anybody know if this can be done? -- Kepior Senso Fumor

Pen Mode in Access 2007

I've created database application to be used as EMR (Electronic Medical Records) in Access 2007 (OS- Win XP). The physicians will be using Tablet PC instead of Desktop to enter their visit notes on this EMR. The visit notes will be entered using a stylus pen on their PC tablet. What I'd like to do is create "Save" button to save that note outside access for editing. Can you tell me how I could do that? someone suggested I use OCR but I am not sure which one to use or how to do it? Our preference is to save that note as MS Word document since that would be the format of the final

No duplicates wanted in column except for default value...

Hi, Having a hard time trying to help myself with this one, so I am posting a question... I want to set a field in my table to have no duplicates allowed except for the Default Value I assign to it... I want to accept multiple entries of the default value, but only single entries for all else... Possible? Thanks in Advance...

Validating two fields

I am trying to create a database in which some of the fields should be mandatory only under certain conditions. For example: In my "Type of Injury" column, I want the user to be required to enter a value in this column, only if the value in the "Type of Document" column is "Nursing Report". Is this possible? I am only just beginning to teach myself Access, so please bear with me. Thank you.

Radio buttons

Is it possible to ask a question in Acess and have the user click on a radio button for the correct answer beside one of four supplied answers (with radio buttons beside each answer) Thanks, Aidan.

Design assistance requested

I apologize for the length of this post. I’m trying to give as much info the first time to help you understand what I need. I haven't done any design in some time so I feel weak on normalization. I am contemplating moving from Excel workbooks to an Access database for our equipment comparison data. I **think** it is worthwhile and need assistance/guidance with the best method for creating my tables. My questions are towards the end of this post. Our process to date … we have one regional standard (RS - consists of two sensors) and many travelling standards (TS – one sensor).

Display Row Number in Datasheet View

Can someone tell me how I can display the row numbers in a datasheet view when a query is run? I have looked and looked and can not figure out where and how I can do that. I just want it to display like a spreadsheet would with the row and column numbers.

best way to archive records?

I am creating a membership database for a church. Individual information is in three basic tables: tblFamily FamLastName (for entire family) Address tblIndividual FirstName MiddleName LastName (takes care of hyphenated married names, or different names for children, etc.) BirthDate MarriageDate tblMembership JoinDate JoinManner TerminationDate TerminationManner and more... Once a person leaves the membership of the church I need to "archive" the information. It needs to be kept for our permanent records. What is the best way to do this? My two thoughts would

Ten calendar harm one of the products

Ten calendar harm one of the products www.laptop-battery-inc.co.uk/spy-pen.htm

Creating a membership database

I am trying to create a membership database for a church. I need to have all members entered into the database, then for the members I need to have their spouse name and anniversary, and the names of their children. I am trying to get a subform for each of these into the main form, but when I try to use it it just shows the spouse in the first spot as the spouse for every record. I need to lock or bind this information to each "Master" form. So that joe smith at 123 anyplace somewhere usa will show his spouse and children while joe smith at 456 somewhere anyplace usa will show h