Search results

If you see what I'm saying then you should know that using bound controls violates normalization and therefore is not advice we should be giving to OPs. Its one thing if we knowingly violate those rules in our own usage for whatever reason. But when we offer advice to others, that advice should...

My suggestion would also work and be simpler to implement. In your example, it appears you are entering values in one table that already exist in another table (tlkpZips). If that is the case, then you are violating normalization rules by having redundant data. Since the data already exists in...

As far as changing the code, there shouldn't be any changes needed. I just created a new database with a single form following these instructions and it worked fine. I've attached it.

glad to assist

Nice Code CK, but it would be easier to have the Zipcode selected from a combo and use the NotInList event to add non-listed codes. This elimiates 2 of your three modules and simplifies the code. Also, you don't mention that City and State/Province should be UNBOUND controls.

glad to assist. Most code snippets you will get here do need to be tweaked to work in your specific situation.

Please don't cross post, I answered your question in the other forum,

You say the images are in one set folder, but you then say you don't have a path. That doesn't make sense. You need to know where the images are. Anyway following is code I use for a similar situation. Private Sub Form_Current() Dim strFile As String strFile = CurrDBDir() & "\images\" &...

Add a Yes/No or a date field to your table. If you use a Yes/No field default it to False and set it to True when a ticket is printed. If you use a Date field, store the date the ticket was printed. In the On Current event of your form yuse code like: IF IsNull(me.txtTicketPrinted) Then...

Add a column to your query with the expression: CurrBD: DateSerial(Year(Date()),Month([DOB]),Day([DOB])) Set the criteria for that column to: BETWEEN Date() AND Date()+7 This will give you all birthdates between today and 7 days from today.

UPDATE tablename SET Todo = True WHERE IDfield IN(SELECT IDfield FROM QryCasesToWork) This assumes that the table that TODO is in has a field that matches a corresponding field in the query But I agree with Neil that you could have design issues

The problem here is you are going in the wrong direction. Its possible for a town to have multiple Zip Codes so you can't just automatiucally assign the zip code. Also, what you are proposing violates normalization rules. If you want to select a ZipCode based on a Town entry, you would need to...

Check the data types of each of your ID fields.

Is the form bound? Is the control bound?

I think you misunderstood something. The expression part of the DSUM needs to be a field in a table or a column in a query or some calculation based on those. It cannot be a control on a form. In your case it needs to be the the field in the transaction table that holds the amount of the...

The octothorpe (#) is used to denote a date value in an expression. What I'm saying is that you should sum your charges and then subtract the initial value from that sum. The reason I suggest subtracting the initial from the sum is that until the sum exceeds the initial value the formula will...

You miss my point. The autonumber is NOT a record number. Its only a unique Identifier. It does not matter what the value is as long as its unique.

Same way you would filter any query. Set the criteria in the query to reference the controls on the form using the syntax: Forms!formname!controlname

The first problem is you didn't use the wizard propelry to create the combo. Otherwise it would have set the column count and column widths properly. The Column Widths property allows you to suppress display of columns by setting the width of the column to 0". A Combobox only displays the first...

I agree with having a form with all the info for REVIEW. But not necessarily for data entry. You want data entry to be simplified and clean. That's why I recommended that entering new Calls be separate. To enter followup actions, you can use the main foirm that you have, but you need to nest the...