Search results

Unable to open the db's in A2k2. The initial dialog asking whether to convert or open as '97 format keeps returning when selection is made to open '97 format. Tried converting, errors reported dialog displayed, then dialog about not finding be file. Once cleared, app window is empty with...

search the forum for "leading zeros". you'll get your answer.

Bad practice to store the same data in 2 different tables. Consider redesigning your tables.

2nd- search access help for "troubleshooting controls" to learn why you might be getting that message. 1st- I'm not sure exactly how you're trying to use the form to manipulate data. Perhaps you can post your form, query and some sample data to give a better idea.

try the name of your date field

A tabbed form? do you mean a tab control on a form? You might try a different approach...perhaps a form/subform with client data on the main form and their employee data on the subform. Then you'd eliminate the macro. Or is the form more involved than that? BTW-welcome on board!

In report design view, click on View|Sorting and Grouping to open a small window that lets you set those options. Or, if your report hasn't yet been designed, you can use the report wizard to help you out.

The answer is in your question: should be the crieria for your query's date column. Then your query will prompt the user for start date and end date parameters when it is run. Base your report off that query and use grouping and sorting options to separate the months in the report.

AN60 2. Set Limit to List to Yes Doesn't that prevent your new code from adding to the list?

Set the Format property to: 000000

Just guessing: tblFilms FilmID CopyID Title (other info) tblEvents EventID EventDate Promoter FilmID CopyID (other info) In short, if you have multiple copies of the same film, and may send them out to multiple events on the same date, then I'd say you're gonna...

Glad to point you in the right direction.

Access help has a list of all possible input mask characters and their meanings. you can write your mask to do whatever you need by using that list as a reference.

Back to the 1st question: From Access2k2 Help: You can recover a Design Master if the file has been lost, damaged, or moved. However, this option is unavailable if the currently opened replica is a partial replica or if the Design Master is moved with a tool other than Replication Manager...

While you're waiting for Kevin_S to get back with you, may I suggest you search the Access help file for "autolookup query". That might be an option for you.

Groundrush, as I said in my reply to your private message, maybe someone with more experience than I can help you out. Frankly, after I looked at your DB, I'm lost as to where to start. :o sorry I couldn't help

Post the sample please.

I've done this in my recent project by using a combobox with a value list. [as opposed to a lookup] requires no code or buttons, just a combobox as the contol. [This is, I believe what Rich was describing above] I list the 11 standard departments for tradeshow crew assignments, but with "limit...

bisuit72, No answer here, but please enlighten a curious newbie... I see "UPC" in your code, which tells me you're using a universal product code, perhaps from a barcode scanner... am I reading this correctly? [Again, just curious]

the property "limit to list" should do that, shouldn't it guys?