Search results

Thanks for the suggestion. I tried looking up some information about that function and couldn't find any, so I went ahead and tried it using the date's serial number as its only argument. Unfortunately, the result was an #Error message. Do you have any other ideas? Or know where I could find...

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...

Thank you so much. The code you provided worked great. Unfortunately, I was unable to find any when I ran a search of the forums before posting my thread. So it's a good thing you were able to help me out! :D

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!

Thanks for getting back to me so quickly on this. However, the query only filters records from a single table, so there is no linking issues. Also, the query doesn't appear to be the problem since I can update in the query's datasheet and in the form based on that query when I open it directly...

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...

I still get the following error message when I try an unlinked subform. "The table 'TableA' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically."

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...

This is my goal: I have a form in which users type "issues" that need to be researched. Then the clerical staff needs to assign that issue to a specific subgroup of people - preferably spreading the work among those who are available. In order to accomplish this, I have added an "Auto Assign"...

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...

Sorry for the confusion. Once the case is assigned to a supervisor, there should be no change. In other words if Joan is assigned the case, she keeps the case until it's been resolved. As for the criteria (and thus the reason I need assistance), the default value should be whichever supervisor...

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...