Search results

I've been fighting with this problem for a while now. I have a union query that joins the results of about 10 select queries that are all structured the same way but for some reason, two of the select queries are causing an error. I can run all of the queries individually except two of them...

I'm reverse-engineering an old Access database file I inherited. I'm basically just looking at the various components and trying to figure out what they do and how they do it. I've come across a couple queries that run fine (as far as I can tell) but won't let me go into design view to look at...

Users enter customer information into a form I created. The underlying table has an index set up to prevent users from entering duplicate customers. The index is made of two table fields (last name and phone number). I've got error handling set up so that if they enter a duplicate customer it...

I'm trying to open a form to a specific record using the criteria in the docmd.openform command. I know the criteria are correct individually because they both work when I use them one at a time but when I try to put them together I get errors. Here is how I have it together in it's latest form...

We have a split database with an Access 2010 (runtime) front end and an SQL back end. The front end is accessed locally on several Windows 7 tablets that are shared across three shifts of users. We occasionally have trouble with our update process which is a batch file that overwrites the local...

I have a tab control with 8 tabs, one for each hour in a shift. There is a subform on each tab. Some of the subforms are re-used since they are identical to each other (there is a 1,5 form, a 3,7 form and a 2,4,6,8, form). I'm looking for a way for the subform to know which tab it is in when it...

I've got some forms that I've set to lock controls based on an added tag. I have a loop that goes through the entire form and disables (controlname.enabled = false) or locks (controlname.locked =true) all the controls with that tag. This appears to work fine when the form is on a blank record...

I'm creating a new thread similar to one of the same title that is a bit old. I have a date/time field on a form that has the default set to "=now()" which puts in the system date and time. I need to change it so that the date changes to the next day any time after 11:00 PM (instead of...

I have a table that contains readings from several pieces of equipment as well as the status of each one. Each record has a timestamp, equipment number, status, etc. What I want is to create a query that will return the latest record for each equipment number. Simplified example table...

I have been building a database that includes a field that timestamps each record in several tables. The tables have a date/time field (LoggedAt). The forms use a default of =now() to produce the timestamp which includes the entire system date and time. This all worked great until I started...

I have a query that works fine in my database before the tables are migrated to SQL. When I run the query after the tables are moved the query returns #Error in each record. I think it has something to do with the date/time data type but I'm not sure. In Access the field is Date/Time data type...

I just discovered a couple forms in my database that won't go to a new record when they are opened. I can add records directly to the table so I know it's not locked. I have many other forms that are set up this way that don't have this problem. On the Form_Load Event I have the following...

The database I'm working on is used to record machine readings several times a day. Management wants a report to show when there are large gaps in the time between readings (to show if/when they were missed). I'm calling this a "Gap Report". Each record is a set of readings and includes the...

I have several forms that are set to open on a new record. I'm finding that while I'm working on the design of these forms I'm creating alot of blank records. This makes me think that when users start opening these forms, they may end up creating a lot of blank records as well. I think this...

I just figured out how to pass a value from one form to another. Now I need the second form to Update that field so that other code will run the AfterUpdate Sub: Private Sub cboAssetNumber_AfterUpdate()Me.txtCompressorID.Value = cboAssetNumber.Column(1)Me.txtArea.Value =...

I'm working on a project that uses a barcode scanner. The user will scan a barcode which will choose an item from a combo box. The result of what it enters will populate a text box. I have that part working fine. The next step is to get it to open a form based on the value in the textbox. The...

Access reports are rather new to me. I know what I want should be quite simple. I will soon be working on several other reports. If anyone has a link to a good tutorial it would be appreciated! I've been struggling with getting a report to simply count records (I don't need any detail other...

Our company uses ID numbers instead of names as the Network Login ID. I have a user-defined function that uses the LoginID as the default in a field on my form. The code is below: Public Function LoginName() LoginName = CreateObject("wscript.network").UserName End Function I just put...

I haven't done any testing yet on splitting the database I'm working on but a question came up today about networking. This database is going to be used by a few equipment operators to record machine readings on the manufacturing floor. There is a wireless network and we are in the process of...

I need to do a calculation on the RESULTS of a query. Each record in the table I'm querying has a date stamp. I have a query that produces a list of the newest records for each machine. I want to calculate how old each of those records is based on today's date. So far when I try to include...