Search results

Makes perfect sense. Here is how I would do it: tblQualityControlSteps QCid (PK, AutoNumber) QCdescription tblQCdata QCdataID (PK, AutoNumber) OrderID (Order or whatever is being QCed, FK) QCid (FK) Passed (Yes/No) Enter the data for each QC step into the first table. You can then use a...

You will need to have it test for Null. Add the following: iCoverID = nZ(![coverID],0) sMarking = nz(![marking],"") I'm sure it's possible to set the size of the form, but i've never done it, so wouldn't know how to do it. Sorry.

Well, when you use the transferspreadsheet command, access tries to help out by "guessing" at what the fields data type should be by analyzing the first row of the spreadsheet. So in your case, since the fields that contain dates are blank, it assumes that the fields should be text instead of a...

I generally do what you described in the second option. I import at least 3 files a day. (2 csv files, 1 xls file). I import them into temp tables, fix the data, then append them to their respective tables. As for the steps, based on your description you would need the to the following: 1. use...

What is the purpose of adding the conter to the fields? Are you trying to count up the instances of each unique value of FieldA? If so, you can use a query to count that up.

Alright, here is a demo. Form 1 displays the data in both a subform and a list box. Form 3 does it this way: and I made a typo, it should of said CAN'T create text boxes... So, I put 10 text boxes for both CoverID and Marking. In a nutshell, the code behind the after update event for the...

I normally use 0 for No and -1 for Yes

Hmmm...well, off the top of my head, I would use the temp table idea. Would you be doing one item at a time, or doing a batch of items? I would open a recordset, grab the quantity and use that for a For Next loop to add the Item number to the temp table. A bit busy here at work right now...but...

A lot easier to create an Sql Statement and then execute it. Less confusing and less lines of code. Example: Dim sMySql as string sMySql = "INSERT INTO tblTableName (Field1, Field2) " & _ "VALUES (" & me.txtbox1 & "," & me.txtbox2 & ")" currentdb.execute sMySql

Are you having problems getting the barcode to print? Also, is there a reason why you need to barcode to display itself 5 times?

The easiest way would be to have a subform that has the data you want to display...and link it via the Combo box (Parent) and TankID (Child). You can use a continuous form. Populating text boxes would be a pain in the butt, because you can create text boxes on the fly. So, you would have to...

Did not know that. My bad :)

Option Explicit Function BuryPostCode() Dim dbs As Database, rst As Recordset Set dbs = CurrentDb Set rst = dbs.OpenRecordset("SELECT First_Name, " & _ "Last_Name FROM Members_Contact_Details;") dbs.Close End Function

Thats a bit out of my league...never had to do it, so never really looked into it. We do our shipping via USPS and I get delivery confirmation reports so I import them. You might want to possibly enter a tracking number and note the web address. It it look like there is a set format for the...

After looking at your relationships, I can see why you are having issues. You state that frmEARP is the parent and frmAppProcess is the child. Based off of the relationship, ClientMain is the Parent and both EARP and AppProcess are the child. The only way EARP and AppProcess relate to each other...

Well, if the data you are looking to display about Tank Covers is already in the query and the form is bound to that query, you can just add the fields. Alternately, you could use a form/subform to display all the data about all the particular tank cover data. The main form would contain the...

Figured as much...just wanted to make sure :) There in lies your problem. Subforms should be the Many part of a One to Many Relationship. When I read your post, my perception is that there can be many AppProcesses for each Client. So you would open up the Client Form with the Client you want...

Well, off the top of my head, here is how I would start the project. 1. Design the Demographic table with the relavent data. 2. Design the Question Table. I would design it as follows: tblQuestions QuestionID (Primary Key) QuestionaireID (Foreign Key) Question (Actual Question)...

I'm a bit confused...you cant put a command button on a table. [/FONT] Are you trying to enter data in the frmAppProcess with a record being displayed in the frmEARP? frmAppProcess is linked to the frmEARP via the clientID, correct?

What I was getting at is that you are storing the same type of data in two different tables. Both tables (Categories and Categories_1) have identical field names. You should only have one Catagories and SubCatagories table. If you are only going to store 2 catagoryIDs in the Organization (They...