Search results

Yup, once you got the data settled, then it's on to reports. They pretty much have the same concept as forms (Forms and Subforms = Reports and Subreports).

Well, I am assuming that you have an ID field. You could do something like this: Dim lngLastIdNum as long lngLastIdNum = Dmax("[IdNumber]","TableName") if lngLastIdNum = Me.IdNumber then 'Do what you need to do end if

When a form loads, the record source(s) for the form, list boxes, combo boxes and subforms are loaded up. If you make a change to the underlining query, then yes, it will reflect those changes. So if you add products to your table or make them as Obsolete, then it will be reflected in the combo...

What you want to do is to recreate the Employee Table so that the data in it is identical to what you already have stored. So, for example, in your posted picture, you have an employee named Tara Johnson. She already has an ID number assigned to her and it's stored in a pre exsisting table. When...

Yes, my bad. The EmployeeID should be autonumber, this way you know that if you add more in the future that you dont wind up with duplicate ID numbers.

I did notice that you have quite a few ([whatever_A], [Whatever_B]). When you have instances of that, you have to ask yourself "In the future, will there be more of that stuff that will have to be recorded?". If you answer yes, then it's a One to Many Relationship, which will require it's own...

you have to use a loop in your code. Dim db as dao.database dim rs as dao.recordset set db = Currentdb set rs = db.openrecordset("YourQueryName") with rs .movefirst Do Do Until .EOF 'Your code here .move next Loop Loop until .eof end with set db = nothing set rs...

Create a query with what you want to export and set the criteria for the Open/Closed check box to Open. You can then use that as your record source for the code to export.

I'm guessing that the OP has a table where he has fields like: quantity1 Cost1 quantity2 cost2 quantity3 cost3 etc, etc Which is obviously a violation of Normalization. Just my 2 cents worth.

Happy to help!

Now you can see why having a database with the table setup correctly makes things a whole lot easier :) I wouldn't worry about it too much...as tables shouldn't be use to input data. Those +s show up when you setup relationship in the Relationship window. Without seeing the actual db, i'd...

Replace the code with the following: Dim sMyNumber As String If Len(Me.TrackingNumber) <> 12 Then sMyNumber = Mid(Me.TrackingNumber, 17, 12) If Len(sMyNumber) < 12 Then sMyNumber = "" End If Me.ModifiedNumber = sMyNumber Else End If As for learning how to code in...

Is there something that is always present in a UPS barcode? And what number are you attempting to pull out of the UPS tracking Number?

Hmmm...works for me. Try TNE 155905. Try pressing Enter after you select the TNE number. The subforms refresh on the After Update event of the combo box.

A bit about Databases. Tables are used to store data. Queries are use to gather data up without having to go into the table itself. Queries 99% of the time can be used in the same place as tables. Also with queries, you can filter the data by adding criteria. Forms are used to Add/Edit/Display...

It's because Access doesn't know it's a UPS barcode. There needs to be some criteria to test to determine where the barcode comes from. Is there anything in the FedEx barcode that will always be constant? Same question for UPS? Worse case, you can use an Options button to determine. I'm...

Work is REALLY boring today :)

I got a feeling that you have some normalization issues....might want to look into correcting that. Also, storing totals is not normally done. You can generate the value you are looking for in a query. In the query, create a new field and put the mathmatically formula you want in. Like this...

Might want to save it as a MDB file. Not everybody uses A2007 and you will generate more help if more ppl can see it :)

In Control Panel --> Administrative Tools --> Data Source (ODBC) you should see a list of ODBC drivers installed on the system. You need to make sure that the driver version supports the version of FMP that the data is in.