Recent content by jamason07

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

Wow....I was hoping it was going to be something a lot easier than that! I'll give that a try....but I can tell you that looks a little out of my scoope! Thanks! JAM

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

OK...some updated info. I've tried copying the table and it won't even let me do that. I've tried to open it via the table directly and through the query and still can't get to the data to see it. I think I'm screwed on this one. Fortunately I've got a back up. I may have to rejoin the front and...

Hey Guys... Interesting reading. I did read something about being next to a radio transmitter and stray waves. In actuality....the main computer sets next to multiple radios. I'd hate to think that this is causing my problems because there is no way around that one. As far as salvaging the...

The record source is a query. Initially I thought the query was the problem but the design was all good....very basic stuff. Then I went to the table and found the line and couldn't delete it. Ideas? JAM

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

Edski, Thanks for the suggestion but it didn't work. The unusual thing is when I take out the conditions on the macro....the button works fine. The button also works when I include only some of the conditions but not all. I've run the step feature on the macro and there is nothing out of the...

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

Awsome! Worked like a charm! My users will thank you! JAM

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

Mucho gracias everyone. Both solutions worked like a charm...with a little modification. Thanks! JAM

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