Search results

OK just to play devils advocate, what's the difference between having the manufacturer id rather than the manufacturer name?? Isn't it basically the same thing???? and doesn't it cut down on the need for tables. I'm not trying to be facetious, but trying to understand the advantage of one over...

another example; I have a table with manufacturer of equipment and then model of equipment. Is it best to have a separate table with each and an autonumber?? Tbl1 Hover Mower Flymo Grasscutt Tbl2 nice line so smooth quitetrim lower Or should I keep manufact & model in one table with an entry...

Is it important to use autonumber when creating tables? I have seen some examples of tables when looking at other options like cascade combo boxes etc and they always seem to contain autonumer as the key. For instance, if you have two tables, one for countries and one for continents, why include...

like that a lot, that is superb

I guess its a cascading combo box solution. select item from 1st combo box which limits choices in second combo

I would like to restrict the options available in field 2 based on the selection of field 1. Would vba code be required in the "after update" field? Would it be an if statement? if a is selected then 1,2,3,4? if b is selected then 5,6 etc, etc...?? I would really appreciate guidanance on...

ok so still banging my head against the computer. Have figured out that I need to put some code into the load event of the new form for it to add the new data. Am cutting text from a book and trying to bend it to my needs, though I don't really understand it (not a good combination I know)...

OK that works nicely, however now that I have checked that whether the customer exists in the database I want to continue filling out the original form. Is code needed to continue on with the original form, or is it a command of some sort?

as you can probably tell, I'm new to this. The code has run through me several times, with me getting closer to the solution?? Can anybody tell me what is wrong with this as I am getting syntax error at the dlookup customer section. Private Sub customer_notinlist(newdata As String, _ response...

so is the best option to stick with the between dates?

so is the best option to stick with the between dates?

I have a date field. I have a query which runs between start and end date, but obviously requires the dates to be typed in. Can I set up this query so that I only have to type in the No of the month say 8 for it to return all the records in August?

cheers. That has sorted it!!!

I am running a query where I total up Numbers. I have clicked on the fields to assign the properties as general no. with 2 places, however the result returns with more that 2 decimal places. what should I be doing to ammend this?

wicked, thanks that worked a treat.

I want to update three fields in the master table, based on matching fields between the master table and an imported one. I know it needs to be an update query, but am at a loss as to how to work it. Any assistance would be appreciated.

I have the right titles on the edit section of the switchboard. (the correct titles are showing up on the top title bar of access. But it's on the actual page that it's still "Main Menu". If I go into design view I can only see 1 switchboard with 1 title??

I have created a switchboard with various pages which I can move between. Each page has the title Main menu. How can I change these to show what should be the title of different pages?