Search results

To add on to what David said: I'm pretty sure that is where your issues lie. If you have an ID number assigned as a PK, then trying to insert a record with the same number will throw up an error. Also, if the data being brought in is a debt number, I would store the debt amount(s) in a separate...

Or you can just modify Query1. Use this sql: SELECT tblPurchaseOrders.VendorName, Count(tblPurchaseOrders.PO_Number) AS CountOfPO_Number FROM tblPurchaseOrders WHERE (((tblPurchaseOrders.Amount)>2500)) GROUP BY tblPurchaseOrders.VendorName; That will count up the number of POs over 2500...

I print off barcodes on all of our order forms. All I do is change the font to Free 3 of 9 Extended. At least for me, the only thing I have to add on to make it readable by a barcode scanner is an * at the beginning and end. I generally add the * in the underlining query, so it would look like...

Did up a quick little example based on the data you provided. Check out Query1

I dunno about having to start from scratch, but restructuring your tables should be the first priority. Me, personally, I would create a new database, construct the tables properly, then link the tables from your old db into the new one. I would then use Append queries to get the data into their...

Connection Strings

I think you need to rethink your table design. It will make things much, much easier when it comes to getting the data that you want. From what I saw, let me see if my assumptions are correct. You are trying to track the expenses of an Employee. These expenses are generated per trip. Each trip...

Design a query with the 3 fields. Set the criteria for the amount to >$2500. Then, click on the sigma (the Uppercase E on the menu bar). That will add a new line (called Total) to the fields. Add the Purchase order field again and set the new field to Count. Also change the Total for Amount...

Glad I could help! Wouldn''t want you staring at the screen too long ;)

Yup...it's a syntax error :) I dunno what the START /I is...when I want to launch a program, I use: Call Shell(sFileLocation, vbNormalFocus) So for your case, sFileLocation would be: sFileLocation = "\\P12abi\amtemt\InitCarlSimon\InitialiseAMTandEMT.exe /cmd /inifile:" & _ chr(34) &...

Nope. When the talk about storing duplicate data, they are referring to actual data, not the Primary Key/Foreign Key relationships. Duplicate data would be storing the customer information (Name, address, phone) in both the Customer Table and the Job table. This causes problems because if the...

You are telling access to open up a file with the extention of lnk..which is just a shortcut. Have it point to the actual exe that launches your program and you should be good to go.

Create a query where you list all the Employees who have completed the desired training. Save it. Create another query using the previous query and the employee table. Join on the EmployeeID. Set the join to include all records from the Employee Table and only those who match from the training...

What you want to do is to store the CustomerID with each Job.

The flag that went off in my head is this: Especially when you mention a primary key. Are you using a pre-exsisting field as your primary key? I import at least 3 files a day, and this is how I do it. I import the data into a local temp table. From there, I do whatever processing of the...

*takes a deep breath* The reason why you cant make Code the primary key is because it's not UNIQUE. A primary Key has to be unique. Add another field, call it TeamCodeID and make it an autonumber. Things you should REALLY change: 1. You have used RESERVED words as field names (Code for...

You need to give it a row source. (It would be the table that stores the data you want to display. TBL_Travel Team code i believe). I would also STRONGLY suggest that you add a primary key to that table. You include the rows that you need. (Code (I would change that name, CODE is a reserved...

I'll try and recreate your db based on the info you provided and see what I can do. Couple of questions: 1. Date of Contact is stored in what Table? 2. Deadline Date is stored in what Table? Also, is there a reason why you are storing the Deadline Date? You could always calculate the...

You dont change the table, you change the form. To reference the column, it would be this: Me.ComboBoxName.Column(x) Remember that when dealing with combo boxes, columns start at 0.

Well, the problem is, the advice that was given was sound and should work. A lot of times, it's something small or a miscommunication and seeing the db usually clears up the issue. But since you cannot post the db, it's tough to troubleshoot with just going by description. Would it be possible...