Search results

I can find plenty of help on converting a date (1/1/2005) to a serial number, but how do I reverse the process? I'm importing data from another program that stores dates as serial numbers. If I use the Date() function in Crystal Reports, it converts fine, but I'm not having the same luck in...

How can I set up a form to NOT open if the underlying query has no data? This feature is nicely available in reports, but how can I do it with forms, too? Thanks in advance!

I have a form (frmAssign) based on a query which when opened directly from the database window allows me to update any of the fields. BUT when I open the same form from a coded button on a different form (frmLastAssignment), my efforts to update any of the fields are thwarted and "Recordset is...

Form #1 allows me to modify/add data to records in Table A. Form #2 is restricted to displaying (no edit, add, delete capabilities) information from a query that is based on Table A. I need to find a way to open an instance of Form #2 while in Form #1, but I keep getting the following...

But I've made an attempt at some code. Of course, it's not working, so I'm turning to the experts for some help. First: The Situtation I have a form used to enter issues/problems our customers call about our service. These issues then need to be reviewed by a staff member. In an attempt to...

I'm at a loss. I found the following code which I am hoping will work for me, but it was written for finding a value in a form. The data I need is located in a table or a query (depending on when I'm running it). What data type can I use to pass the name of the table or query (currently...

I'm hoping someone here can help me out with existing code or at least point me in the right direction... In one of the databases I am developing, I need to set up the ability for one field in NEW records to be autofilled with the next value from a table or query. Details My database includes...