Search results

I looked at the Bookmark controls but it would appear to cause the same problem since the bookmark would be lost when the main form is closed by the SetValue. Any ideas on how to pass a selected value from one form to another? So I create a new topic for this? Thanks again. :)

I thought about and tried that but I am using a SetValue to tell the detail form which record to display and the SetValue closes the main form when it runs. Is there a better way to send a value to a query/form without using SetValue?

I currently have a form that displays a number of records and allows the user to double-click on a record to open up a detail screen. The problem I am running into is that as soon as the user closes the detail form and reopens the main form (with all of the records) it goes back to the top of...

Sweet!!!:) Thank you both for the quick replies. This worked perfectly!!!

Okay, I set the Tag on the tab to the name of the tab it was at on close but for the life of me I cannot figure out how to set the focus. I tried the "GoToControl" option in the macro for the form but no luck. I am probably missing something simple here....:(

I have a main form set up with 4 tabs within. Two of the tabs have buttons that close the form to open a new one. When that open form is closed the system returns back to the main form but it resets itself to show the first tab, no matter which tab was open when the main form was closed. Is...

Thanks, I'll have them look into that!! Brian

Out IT department updated to SP2 this weekend and about half of my reports are no longer working. I cannot view, print or go into design mode. The error I am receiving is this: There was a problem retrieving printer information for this object. The object may have been sent to a printer that...

Is there a way to use this code to open a published Outlook form?

Sorry for the double post but does anyone have any ideas? :confused:

Thanks Pat!! :) I didn't think it was possible but I wanted to try. Of to the module I go. Brian

Sorry, should have used a more specific example. Basically I am searching a Fee field in another table (field name is cd_fee) where the user can either see all of the values, all of the values less than an input amount, all of the values greater than an input amount or a range of values between...

Is it possible to have operators (<, >, <=, >=) in an IIF statement like this: iif([field a] is null, > [field b], < [field c]) This is in the criteria for a currency field. I have been trying different combinations without any luck for the last couple of hours or so. :confused: :confused...

Also to clarify, what I want to do is export stored data from a table in Access to a webpage. Basically take the data in Field A in the table and copy it into Field A on the webpage. Thanks again Brian

XML is a possibility as we are using it currently for GM, Chrysler and Ford but Toyota, Mazda and a few others are not as Fleet based as their American counterparts. Since this is uncharted territory for me do you have an examples of the code or an idea where I might find some. I am assuming...

I wasn't sure where I should have posted this question so please feel free to move it if necessary. I am not even sure this is possible and I didn't know where to begin but these forums have always been extremely helpful. What I would like to do is export data directly from Access (via form...

I was searching around for the answer to this but I am drawing a blank. I have a module setup to send an e-mail but I would like to change the "From" field that is displayed on the recipiants PC in Outlook. I cannot seem to find any way to change this. I do have rights in Outlook to to e-mail...

I had thought of that but the database is also used for other functions on some other user's PCs and I don't want the reports running multiple times. I suppose I could create a seperate database for just those reports but I did not want to have to do this as I might have other needs for this...

O.K., one of my databases is used to run reports on a daily basis and currently has to be done manually. What I want is to have this run on a daily basis, early in the morning so if I am not at worh the reports are sent out. I setup the following but it does not seem to work: Using the...

I am trying this in a VBS module. Please check out my thread here if you can help. :) http://www.access-programmers.co.uk/forums/showthread.php?p=322481#post322481