Search results for query: *

Good Afternoon, I have a dropdown menu which, when an option is selected, populates other unbound fields from the table that the dropdown menu is linked to. However, two of the fields in the linked table are memo fields. When the selection is made, the unbound fields are only populated with the...

Good Morning, I've created a command button on my main screen to make it easy for users to synch. But it isn't working correctly. I get a message saying that it can't sync because "one or more objects are open". I'm using the following code: Private Sub Command10_Click() RunCommand...

Good Morning, I have a database that is being used by employees. When they attempted to open the form to do data entry, they recieved an "Invalid Arguement" message. When I researched the issue, I found a line in the data tables that had "#Error" for each column in the line. This was throwing...

Good Afternoon! I have a database that I've built some buttons for that are running conditional macros. Everything was working fine yesterday but when I select one of the buttons, I get an error message that it can't find the form. The form is definately there and all the entries are correct...

Good Afternoon All, I am laying out plans to develop a dbase for managing our departmental personnel. I am planning to have a main form with all the usual information on it with some subforms for other. The one unusual feature I would like to add but I am not sure of has to do with one of the...

Good Afternoon All, I have an unbound field in a report and the report is tied to a query. I want the unbound field to populate with the contents of the first field [field1] but if that field is null...then I want it to populate with the contents of [field2]. I am using the following statement...

Good Morning! I have two combo boxes, cbo1 and cbo2. cbo1 has three possible selections based on a query: list A, list B or list C. I need cbo2 to display the contects of the appropriate list dependent on the selection of cbo1. I have seen this done on several websites that ask for user...

Good Afternoon! I'm trying to use the DLookup function to populate 2 or 3 unbound fields on a form based on the selection of a dropdown field on the same form. The information needed to populate the unbound fields is pulled from a query on which the dropdown field is based. Thus...all the info...

Bob....please see my last question on thread thread181-756346. I've got everything inplace but can't get the last piece working! Thanks! JAM

Hi! I have a form which has 4 fields called "Date1", "Date2", "Date3" and "Date4". These dates are calculated in a query based on user inputs. I have another field called "DueDate". I need the "DueDate" field to display the highest...

Good Afternoon Everyone, I have created an Access application which will be used on multiple remote sites. During the course of operations...I expect to update the application's front and back end. I am looking at putting new versions on a website and allowing the users to download it via the...

Good Afternoon, I've got a big mess on my hands. I inadvertently deleted the backend of my database and I'm trying to restore from an old database. I've been copying macros, reports, forms, etc into the new dbase. Now that I have everything over, I'm having problems with my buttons that are in...

Good Afternoon Everyone, I brought this up once before but I heard from a dbase guru that having multiple primary keys on your tables could prevent you from having multiple users accessing your dbase even if the dbase is split. Anyone have any insight on this? I have a recently created dbase...

Afternoon Everyone, We just received our shipment of Compaq Tablets. I have 3 dbases I need to convert to touch screen and character recognition capability. I spoke with a rep at a convention regarding this and he said that I needed to download some modules from Microsoft. I found those. Before...

Hello! I want users to be able to synch with the master as needed so I put a button on the switchboard that runs a synchronization macro. I created it using "RunCommand" and then "SynchronizeNow".....but I get the box "Action Failed" followed by a "There was...

Here's one for you IFF Then gurus. I have a form that the user fills out which time/date stamps the form using the computers date/time setting. The information needs to be reported in Zulu time. Thus, I have set the [Time] field to calculate with Time()+#05:00:00# to give me Zulu time. However...

I've developed an Access database that I want to distribute to remote users who do not have MS Access. I'm not a hardcore developer but I need to know the easiest way to turn the database into a stand-alone system that my users can operate without MS Access on their machines. Any and all...

I have a database with multiple tables, forms, etc. that I have successfully split. The front and back ends reside on a common server. I have placed shortcuts for the users on their desktops. However, only one user can access a form/table at a time. When the second user tries to access the same...

I would like an audio notification when a condition in met in a form. I've set the conditional formating to change colors. Anyone have any ideas of how to attach a sound wave file to activate when the condition is met? Thanks much! Jeffrey

I have two fields in a form to conditionally format to change color when the field is less than or great than the current date....ie. [Date]+60<Date(). I've been trying to do the same thing for my time field but it is not recognizing the addition of hours....ie. [Time]+1<Time(). I've tried using...