Search results

Attached is a sample database with a form that has two comboxes , one display the drop down using code the other displays the drop down using a table. If you are still having problems post your form to the forum.

Post this code in the LOAD Event of your form. In the code show_time is the name of the combo box used to display the times change this name to the name of your combo box. The drop down is displayed in hh:nn:ss AM format you will need to play with the format to show hh:nn AM in the drop down...

Have you tried creating a form with the form wizard?

Andre Tried to download your file. But a message was displayed saying that the file is private.

If your YEAR field is not in a date format then you will get the incorrect error. If your YEAR field is 1989 an integer then you can use the following to determine the age =Year(Date())-[year]

Charles First, welcome to the forum I hope you gain plenty of knowledge. Please reply to my email address below regarding the following questions 1. I can assume that a delivery could be made overnight e.g. from 11pm to 3am. 2. In your table you have a column Start and End with some values...

Please upload a copy of your database.

On your form have two text boxes one called StartNumber and the other EndNumber. When you enter the StartNumber, use the After Update evnt to set the EndNumber to the same value as the StartNumber. If multiple invoices are required then just change the EndNumber. To print the invoices, the...

In the AfterUdate of the NumWeeks put the following code. Make sure your fields StartDate is a date format and Numweeks is an Integer format For this example I have used weekly_dates as the name of the drop down, you will need to change this name to the name of the drop down on your form...

Locate the directory where database is. Then highlight the database name, hold the SHIFT key down then double click on the database at the same time keep the Shift down until the database opens with the navigation pane displayed.

You will get all the records in my example as I removed the criteria for the user. You will need to somehow include the [name] in the dcount so that you can count on Status = Work AND Users = a selected user etc.

I used vbaInet code and it worked in your database. I have attached your database for you to check.

Taking PNGBill suggestion further you could use TAB or Pages on the form for each step to avoid the appearance of a cramped form. Regarding your "What if" we developed something similar at work where the user made a selection from the historical data this included today and earlier records...

Stick with your current setup. I am using 2007 on Win 7 and found it took me a while to learn the new interface layout and I am still learning. I found that when using the forms wizard 2007 uses embedded macros to perform some tasks which would be shown as code in 2003. I now use a blank form...

Here is a tip that I learnt a long time ago using 3rd generation languages. When using IFs the next line must be END IF then enter your code before the END IF, this also applies to other structures like Loops Select Cases etc.

I updated my version of your database before you posted yours to the forum. I made changes to the recordsource of your Invoice ID and added the two fields, note this layout is not the same as yours. The query used for the recordsource gives you the total paid to date for the invoice and the...

Members beware! PNGBill is an UNION man. Soon he will be asking all members to join the UNION movement.

Are these two boxes on your Add Payment form c_Payments_Add? Please upload your latest version.

In your first example you have Diagnosis as the name of your combo box then in the IF statement you have Diagnosis_combobox. In your second example you have Diagnosis_comboboxcurrent() which should be Diagnosis_combobox_current() Try this in the After Update Private Sub...

You need something like this. Use to BETWEEN for the date range then on a field that should have an observation set the criteria to IS NOT NULL I am not too sure if the following is correct, this gives you the dates between the start and end dates and displays the obervation fields in that...