Search results

That nailed it, CPOD. God, this site has been my salvation on this, my first professional application. I just had to say it. I'd give you guys a great big smilie icon right now if I used the silly bastards.

Well, after having changed the code, I no longer get the error message, but now it won't put a 0 into the Null field; even when I focus into and out of the field manually.

When you base a form off of two or more tables, you must first create a query based off of those tables. At this point, you can build a form based off of the query. Just go to Queries, Design View, add the two tables, and select which fields you want in the form. As long as your relationship...

I have a subform datasheet that I will be having users copy and paste a large amount of information into. The problem is that under one of the fields, I have some code written: Rec_Qty_AfterUpdate if me.rec_qty.text="" then me.rec_qty.value=0 This puts a zero into any Null values for the...

By the way it's acting, it sounds like there's only one record; record 1. I know it sounds like a dumb question, but do you have other records in the database yet? And is parameter in the right field?

What I have is several kits with parts in them that are out in the field. Not all kits are used every single day, but the days that they are used is captured by the date. What I need is a crosstab which lists all the kits in one column, the items as the row, and the number of parts where...

Never mind, I got it; no parameter in the select, must put parameters in the "Criteria" field as well as in the parameter dialog box of the crosstab. Seems kind of redundant, but it works. Hopefully this will help others that will undoubtedly come later needing the same info.

Alright, I know this topic has been covered in former posts, but I'm still having trouble getting it together. I'm trying to create a crosstab query which will accept a user-defined parameter, in this case, a start date and end date. I see that each parameter must be individually defined in...

Well, turns out the form and query that it was based off of isn't doing exactly what I need it to anyway, so I'll have to create a new form and query after all; might as well use the Wizard. Thanks anyway for the advice!

Well, the grandchild subsubform does seem linked to the child subform because it puts a number in the grandchild's foreign key field like I want it to. However, as I scroll through records on the child subform, the grandchild doesn't change to correspond as it should; it just shows information...

I have a datasheet subform that has a child datasheet subsubform. The problem is, the child subsubform won't show up in the master subform (because the master is a datasheet) and when I try to move it outside of the subform's space onto the main form, then the "Link Child" "Link Master"...

I have a form which has a subform based on a query. What I need here is to have the subform (in datasheet view) load with 40 records which have blank fields except for the autonum primary key (which will be invisible), as well as 40 items, one per record. The items are from the item table, but...

I have an invisible text box on a subform that is a foreign key in a table. The primary key that it relates to is an Autonum on the main form and I need the text box on the subform to autopopulate with the same number as the text box on the main form. Any clue as to how to do this?

Is there a way to create a main form with a combo box that holds the primary key entries for every record and then changes the subform based on which record was selected without using VBA? I don't know much about coding and thus would like to use a form wizard or use the properties box to...

Actually, I figured it out. All it means is that I was trying to open the form while it was already open (I was doing some coding while the form was open). Once it's opened it's locked, thus the error message. Thanks, anyway!

I have a combo box on a form which should open a connection string and populate the form with specific data based on a query (Change Event). My problem is that when I click on the combo box, I get the following error message: "Database placed in state by user 'Admin' on this machine that...

I have a bound form that allows the user to enter information about a particular install team and sites that they visited. Easy enough; now what I need is a subform so that I can have a combo box where the user can choose a part and manually enter in the quantity of that particular part that...

When I attempt to install Access 97, I get this error message: Autoexec.bat file is too long for setup to modify. Must edit Autoexec.bat file manually to add the following to PATH statement C:\PROGRA~1\MICROS~5 What does this mean and how can I correct it? FYI, I uninstalled Office 2000...

I have a database that I'm having a rough time with setting up the tables. The database is based off of a spreadsheet which has now been determined antiquated. Here's what is going on: 25 techs go out daily with a kit full of parts. When they get to a site, they use certain parts from the kit...

I'm trying to use two different combo boxes. The first, CmbCharges, gets its data from the Charges table. The second, CmbOtherCharges gets its data from the OtherCharges table. What I need is for the CmbOtherCharges combo box to be disabled by default. When the user selects "Other" from the...