Search results

We're having the same exact problem, has anyone else had a success in getting around this problem other than importing into a new database. We tried that, but some of the VB code doesn't seem to make it, and thing like our tree control on our main menu gets hosed.

Sure, post a sample DB, I'll take a look and see if there is another way to do it.

We use SQL server at my office, but sometime localize tables to make them respond faster. Basically if we have a table dbo.MyTable through an ODBC connection, we create a Make-Table query (naming the table Tbl_MyTable_Local or something), which creates a local version of the data from the SQL...

I'm also running Access 2003 sp2, and tried to recreate the issue you are having. I've made multiple databases in this version, and have yet to come across this issue. I was able to kind of mess up the form by creating a form with a memo box, then chaning the memo box on the form to a text box...

These other fields, are they on the main form, or the subform? From what I understand, you have a form with a drop down box, when a user makes a selection, the subform is populated with data from an underlying table which feeds the subform. Try putting the other data fields also within the...

As mentioned, using the datediff function in a query will work. You can use date() as the second criteria, so the query always uses the current date as the comparison date. No need to create any extra fields. Just substitute you the table name and the field name (Submittal Date). SELECT...

Are you using Vista? It could be Superfetch, basically Vista loads the application into memory. http://www.tomshardware.com/reviews/windows-vista-superfetch-and-readyboostanalyzed,1532-2.html

Another option is to use the scanner to pass a function key to access. Not all scanners have this ability, and the particular model that my offices uses actually can't do this. If the scanner does have the ability to pass a function key, you could code an On Key Down event to open the new form...

I am trying to print out a mail merge, basically 4 pages to a printer which can handle staping. The problem is the printer sees the file as one large document, it does not recognize that every 4 pages is a new document that needs to be printed seperately. I checked the printer settings and...

One way to get this is to break the query down into several different queries, start with this one. Basically it will convert the dates into month/years, replace "table1" with whatever your table name is: Qry_DateConversion SELECT Table1.date, Format([date],"yyyy") AS dateyear...

If you want to calculate it in a query, you can use a nested iif statement like below: Calculation: IIf([Service_Performed]="Move",[NumberField]*2,IIf([Service_Performed]="Disconnect",[NumberField]*1)) It sounds like "Service_Performed" is a text field, so you can't multiply it by a number...

Hi all, Is there any function similar to CurrentUser() in Crystal that would automatically print either the Windows username, or machine name automatically onto a report? Thanks!

Have you tried putting your buttons in the form header instead of the main body of the form? That way even if no data is pulled, the user can access any controls. When in a form just go to View -> Form Header/Footer.

I usually just use one of the below expressions in a subquery, then run a totals query on the sub query to get a count by year/month, as an example the date 9/1/2002 would return: ActualVisit:Format([actualdateofvisit],"yyyy-mm") 2002-02 ActualVisit:Format([actualdateofvisit],"yyyy-mmm")...

Hi all, One of the buttons on a form I have runs an append query which appends a specific client record to a new table, dbo_Tbl_ParticipantData. I would like the OnClick event to trigger a lookup into this new table to see if the record already exists based on SSN. What is the best way to do...

My office recently got digital recorders that allow us to record meetings and then save the recording to .wav files on the PC. I created a database with a field that contains a link to the file. If I link a word or excel document, the word/excel application opens with the appropriate file. The...

Thanks a ton Jon K, it works perfectly. Roeland Kim

If you're downloading the free version of their font, it is only numberic (0-9). If you want alpha also you need to purchase the full version of the font. At least that is what I remember when I used their font a while ago for a project.

Anyone who could point me in the right direction?

In the criteria of the query put something like: Not Like "*" & [Enter Parameter] & "*" Or just this: Not [Enter Parameter]