Search results

I didnt mean I base all my forms on actual tables, I just meant that binding a form to a record source in Access is a snap, while in VB it is a job that takes some time, and I am just giving an example of the simplest thing to start with, let alone having to code "filter by form" and the search...

Although I include in my resume that I devloped with Access for 6 years, I am asked some questions on Interviews like "did you ever use Microsoft Access" or "Have you ever done actual coding yourself?" :mad: Seems that the guys dont beleive :) The only certificate availbale now is the MOUS and...

I did all my database programming in Access. It happened to me once that the client said they didnt have Access and they wanted the application in VB (only to turn out later that they did have Access :) ) And from the very slight experience I had with VB I found that what you can do in Access in...

How about using a listbox instead?

I can see that the problem is a managerial one rather than technical. It is not fair to give you a deadline to finish a project that is locked by a password. Maybe you need to explain the facts to them before they start blaming you for not meeting your deadlines. Best of luck!

Life would be perfect if users and clients understood database design, or Access limitations. You dont seem to be given much choice. I used to design applications that would print barcode labels for assets, and the client simply wanted the barcode to consist of three parts: origin, category and...

ChrisO your friend was absolutely right!! Guess what. When I changed my regional settings to the setting I used before coming to Canada, this piece of code: =DLookUp("[Transactions]![Document]","transactions"," [Transactions]![TransactionID] = [TransactionCode] ") Automatically changed to...

My regional settings is English (Canada). I am not having a problem, because now it is really much better having the same syntax (comma being the separator) all over the application, but I remember before when I tried to re-use some expressions or code fragments and I had to modify the...

It is my first time to play with Access 2002. I programmed Access 2.0 through 2000. In the past, some function calls used to have different syntax in modules than in form, report, and query expressions, like IIf(condition,truepart,falsepart) , in modules as opposed to...

More general case: If you dont know what data will be in the record you can use If Me.CurrentRecord=recordnumber Then .... End if

You can still use jobstart <= date AND jobstop>= date.

If your question is simply can I use a conditional IF in the control source of a textbox, the answer is yes, but with a small modification. You use the IIF() function. =IIF(condition, truepart,falsepart) But in your particular case, the best place to execute code when a command button is...

Also regarding the "Auto-Lookup/Auto Fill in" title that you chose for your thread. You need to know that Jet "Auto fills in" data in case of default values, but Auto-Lookup is something different. It works in queries based on 1-to-many relationships and it merely "displays" related data that...

Normally Autolookup will only work if there is a matching record in the "one" table, in this case the patient table. You will have to check first for the value of medical record number, do a programmatic Dlookup() on the patient table, if the record is there do nothing cause Jet will handle it...

Maybe I confused this case with a case when i used to call a DOS batch file from within Access and VBA used to continue Execution before the Batch file was done!!

The problem is that VBA will not wait for the Jet engine to finish executing the query. It will just pass it the command and then go on executing the rest of the code, so the form will close when the query is still running.

If you know that the query takes 10 to 15 seconds you can set the timer property of the suggested popup form to 12,000 ms and then close it on the On_Timer event. Or if you want the closing of the form to be in better sync with the end of the query. You can replace the update query with a...

Try using ="Your current premium is "& FormatCurrency([premium],.......) & ". Please blah blah..." Here is the syntax for the FormatCurrency function. FormatCurrency(Expression[,NumDigitsAfterDecimal [,IncludeLeadingDigit [,UseParensForNegativeNumbers [,GroupDigits]]]])

Check the type of joins you have in the query. Some records in the table might be missing from the query result because you are joining on a field that has a null value, for example you didnt enter a value for "City" and you are joining to table "Cities". If you right click on each join, it will...

You can create a form and size it like a message box, open it before the query execution and close it after that.