Search results

What I want to do is from several records find the Max() date and update that one record with my stuff. However, I get an error message cannot use aggregate in update query or something to do that effect. Is there a way to get around this?

basically I have two date columns in one of my tables. One is created whenever a record is created in that table the other is added to that record later based on business rules. I need to get all records in the table where the first date exists but not the second. I'm unsure of how to write a...

help, this is driving me insane! (resolved) My query looks like this...The problem is that when I have one Radio with two records where [Defect fixed?] is false it counts that as two separate radios instead of one. Somehow I need to make it sum records with the same Radio/Serial_number as...

at one point in my database I have two tables and for everyone record in one table I may have either 1 or 0 records in the other. How do I express this in access design? Since it's an optional 1 to 1 relationship I guess?

I'm having big trouble creating a report based on a crosstab query I have that asks for a start date and an ending date. Basically what's happening is that when I create one, the boxes for the parameters start popping up in the middle of design view! and they just keep coming... Is it even...

My question involves the table below AutoNumber(primary key) SerialNumber Station Defect Type Date Basically now I need to be able to get the result i've gotten by a date range, but the crosstab query won't let me do it the way you can in a regular select query...help...

One of the tables in the database has these fields st1: st2: st3: st4: Date: pass fail fail pass 10/21/05 fail pass fail pass 10/22/05 and so on. What I need to do is extract the number of passes and fails on each of the four stations and put them into a report. User will...

Is there a way to make it so that access will accept 0 as a first number in a number field. What's happening is that when I try to enter say 0123, the 0 gets cut leaving me with 123. This is not really acceptable and while I can make the field a string, i'd rather find a difference solution if...

i'm trying to use a switch function in a query but i'm unfamiliar with the format a bit. here is what i'm trying to do... switch([Radios]![Warranty] and [Radios]![HousingWarranty]=true,[Radios]![Change front housing]*(25/60*28), [[Radios]![Warranty] And...

This is my code for one of my commands. My Problem is that all of this even on a fast connection to a pretty fast server can take as long as 7 seconds to process and either open the form or not depending on whether my conditions were met. Is there a faster way for me to do this? Private Sub...

Basically, I need to update a certain record to be 'closed' when I hit a button depending on the 'serial number' that is typed in the text box above. I'd like not to bind the form to anything however. How can I do this? thanks,

How many users can an access database support? I'm setting up an app accross 3 workstations but each has multiple users. There may be as many as 1000 records a day entered. Can an access database handle this or do I need to switch to sql server?

Is it possible for someone with access xp to look at reports made in an .mde file.

I have a field in the parent table which indicates how many child tables there should be at the most. I'm uncertain about how to enforce this. I"m using access as the database to a Vb.net app. Should I do it in access or Vb.net or both.

Basically I need to create a bar graph in the footer section of my report using the data that is in my details. What's the best/easiest way to do this? Thanks,

Does true = 1 and false = 0 right? if that's the case why am I getting a -1 for my value when I test that out in a messagebox?

i'm getting the following error when I try to save and close a couple of my forms this action can't be carried out while processing a form or event control my code is DoCmd.RunCommand acCmdSaveRecord DoCmd.Close acForm, "Radio Trouble Shooting Data Entry" DoCmd.Close acForm, "Enter Serial...

one of my dlookup's looks like this varx5= dlookup("[Defect Fixed?]", "Defect_Log", "[Serial_Number]=text5") I need to add another condition in there, but I don't know how I should do it. Do I use And after text5 or maybe another comma and another condition? thanks,

I need to set my part number to stay in the text box if this IF statement is true. Anyone know what property I need to use? Private Sub PartNumber_LostFocus() If (PartNumber = "") Then MsgBox ("YOU MUST ENTER A PART NUMBER!") PartNumber. End If End Sub

I have a subform within a form that when it is loaded is visible=false. I need to make it visible when some condition within the main form is completed. The problem is that their names are form. How do I distinguish one form the other in my code?