Search results

I have a set of queries that will Approve and Revoke Credit Approval based on given criteria. The field giving me a problem is the [ReviewDate]. I want the [ReviewDate] to be not more than 6 months old. This date is held in a table I'm linking to via ODBC and the field is formatted as text (I...

I have put simple error trapping into a module that performs some updates to access tables from Excel spreadsheets. I have trapped if the table doesn't exist but now I need to trap if the table is locked or open. Can some one share the syntax for this Test. Someting like this is what I'm...

Thanks, I've seen her name on several samples I've found. I'll dig deeper in her site.

Here is a little Detail Request Screen I use to allow employees to email a request to me and also add them to a log. I show a lot of carriage returns (vbCr) for formatting my output. 'Email Notice Dim strList As String Dim intcounter As Integer Dim olApp As Outlook.Application...

I'm building an application that tracks quotes and have implemented some outlook modules to send emails and schedule tasks for the employee. Sending information into outlook has been fairly easy. The hurdle I'm trying to get over now is how to retrieve a list of tasks from each user. (My boss...

I just needed to set the multi select property of the list box to "simple". And then anything that is selected in the list box will be sent to my email. Pretty cool feature. I still think I may be doing this the long way, but it works.

I don't know how easy it would be to integrate my approach into what you already have but I have built a DB that imports data from several existing spreadsheets using a series of macros and queries. Excel is never actually opened that I'm aware of. I used the TransferSpreadsheet Action under...

I have a DB for requesting Details of Products. My sales coordinator enters the Job information on a form linked to a Request table and enters the parts needed in a subform linked to a Detail Table. I'm using code to create an email populated with data from the Job Info form and want to also...

Thanks guys, I'll take this and chew on it for a while. I think I see what your saying. Thanks for all the great feedback.

Thanks for your quick responses. I'm sorry to have such a tough time with this concept but for some reason I just am not grasping how this works. I have a database on my server that everyone is working in to track quotes to customers. The data is stored on the server in the Q:\Database.mdb...

So, if I follow: The diagram attached would not work by only installing replicas of the design master. I would need to install a replica of each of the upperlevel databases on the laptops as well? Forgive me if I'm not grasping a concept that is simple. I just want to make sure this plan is...

I have created a replica of a database that has linked tables in it. Some of these tables are in other databases and some are linked via ODBC to other databases. I created the replica with little issue and when I sync with the Design Master the replication process appears to complete...

That was perfect Pat. I'm curious to see how many forms I can weed out using this little gem. Thanks for the fast response.

I'm trying to populate a field on single form with input that could come from three different forms in my database depending on which department is using it. I keep getting a #Name? in the field instead of the job number. In the forms OnOpen event I have: If...

I have a windows 2000 box with access 97. The user wants to put a shortcut to a form in a networked database on the desktop. When we try to open the form Access tries to open but freezes up and never makes it to the database. When we close access it says it "can't find c:\machine\documents...

That's Perfect! What did you search for to find this article? I looked all through Microdsofts site and never found anything to address this so specifically. Thanks for your help! Happy New Year!

You are correct. My sales reps will be traveling with this application which is a central database for my internal users. They want to be able to enter comments about projects they have followed up on wile disconnected from our network, then sync with the mothership to swap updates. Is that...

I'm trying to create replicates of an access 97 database. When I click replicate I get an error message that says "Mocrosoft acess can't convert the database to a design master" due to one fof the system tables created by the replicate action. I've tried the sample code from microsoft to make...

Thanks for all the input. I wound up putting a cmd button on the subform that the user will click to modify the detail data. Then after the user submitts the form I open the report for them to print and close the form in the background. If the user opens the form again the allowedits is...

I have a subform in an form that on open checks some criteria and if true changes the AllowEdit property to False. If the user wants to modify the data on the form or subform they click a button and I want to change the AllowEdit property back to True for both the form and subform. The button...