Recent content by hyperpau

To convert the date time to mm/dd/yyyy hh:mm:ss, go to the desing view of your table and apply a format. I think this is Long Date found in the dropdown menue. To get the state of the most recent, you would need to use the DMax function. Assuming your Date Time field name is dteDateTime...

This is really what's gonna happen because the field does not exist in your query but only as an unbound calculated textbox in your form. To resolve this, add a realtime calculated field in your query. And since the form is bound to the query, you can then add that field as a control to your...

Your problem is a simple one-to-many relationship. The thing the confuses me in your quetion is that you are talking about tables and not forms. so what click events are referring to? I guess you mean that your forms are linke to these two tables? And when you say select from the List, is...

Looks like you would use the IIf() and DateDiff() functions in your Query through a calculated Field (realtime) and use that query as the base of your form.

I would suggest to add that username field in your forms. Then have a pop-up that asks users to login. Upon loggin in, assign their usernames to a PUBLIC variable. You can then use that variable to all Forms in your project and then use it to compare to the Username field in each Form. If it...

You may do this by first, making sure that field names of your quotation form are matching to the field names of your invoice form. That means the field names are the same for both tables each of them are linked to. Add a Quotation ID to your quotation table and make it as a foreign key in...

Seems like the only way you can do this is to change the format of your field to number by going to the design view of your table.

I have done tons of access database with vba codes on it. And this is what I always do. never did my clients encounter any problems with my design. Well i guess were entitled to our own opinions. seems like this forum is not really into that. instead, they put big fonts in bold format as if...

That is always a good alternative. But if you do that, you need to do the wizard everytime you add that field to a form. But if you do it on the table itself, then every form referenced to that table will automatically have that field as a combobox. Ok?

it's easy, make sure that on the table itself, it has that field which is a look up to that other table. in the design view of that table, go to the field where you want it to be a lookup, then select the type as look up wizard. Then there would be a pop up that would just ask you which table...