Search results

I tried that in the beginning, but it caused different problems. First of all, I have 2 separate fields; one for the month and one for the year. (both needed in 2 digit format) When I enter a date in the year field of, lets sat 09, with the field set to date, I now get an error "The value you...

I have 2 fields on a form that I need to display month and year of a Credit card expiration date. I currently have the fields as number format. I need the fields to be displayed (and also stored if there is a difference) in the format of MM and YY, meaning the leading zeors in January (01), or...

I'm trying to get to know the workings of the QODBC driver. I've been working on an Access DB on and off now for a while with intentions on connecting it to our QuickBooks data when finished. I downloaded the trial, set everything up and can connect to QuickBooks, but accessing the data is...

OK here it is. Open the report from the Daily Driver Reports Daig form to see the issue I was talking about. (and opening straight from the database makes no issue) Then change the afterupdate event of the preview button to acviewreport and then everything works. It doesn't really matter...

Yeas sure give me a little bit to remove personal data and shrink it and I'll post it in a few

OK if anybody is still following this I figured it out but have an interesting issue, but I think it just might be a bug in access. I got that theory from reading this and my situation is not exactly the same but similar...

Oh thats a good idea. I never thought of two subreports side by side. Right now you are correct, I am linking master/child on driver ID, and hence if (right now) there is no record in the master report the subreport will not show. I'm gonna try your suggestion now, but will I need to link...

Well thats what I kinda came up with, but can't exactly figure out the 2 column thing with the subreport. But anyway, I've decided to eliminate the 2 column display and just use the subreport and have the second list (canceled customers) under the first (new customers) which works, but now...

I am trying to create a report with 2 colums of data, but if at all possible, I need each column to be filtered. Example... The report is a dialy sheet of new customers and canceled customers, sorted by the driver that services those customers. In column 1 I need the list of NEW customers and in...

Thanks for that suggestion. I'm going to retire on working on this DB for the evening, but will try it out tomorrow and let you know how it works. in the mean time I did figure something out. It's not the prettiest, but it works for what I need. I disabled the close button (x) and made my...

Technically speaking, yes, when opened from the customers form, the orders form goes to a new record, HOWEVER, as stated above, it also passes an openargs value of the customer account number and enters it in the appropiate field. That account number field in the orders form lookups that...

I need to cancel or delete the current NEW record from saving when closed, but only when certain criteria is being met. It seems simple enough where I should be able to figure out by myself, but I can't get it right to cancel under my certain circumstances. What I need is for... If my orders...

Thanks for your help!!! That worked great! Just one more quick question and I'll stop bothering you :) Everything is working now and I probably shouldn't change anything if it is wrong, but is the structure of all my tables correct? Also, in the Customer details table, is the control source...

Oops, sorry. That field was suppose to be deleted. It was for something I tried before that wasn't working. Well that's part of my problem. I need to remove the house number from the address field then "lookup" that street in the addresses table. A quick thought I just had was adding a field...

I believe that they can. I posted this same question a little while ago and someone answered/suggested that I normalize my data first. That original post is here: http://www.access-programmers.co.uk/forums/showthread.php?t=186553 I then split my Addresses table into 3 separate tables, according...

Thanks that worked!!! I knew it had to be something simple. What about the update query now to change all existing customers?

Thanks for the response... I've seen and referenced that site before, but I don’t think it's helping me in my situation. I am trying to use a variable in the criteria section and that site mentions nothing about variable syntax. The Help file in access gives a good example of how to use a...

I have a customers form (based on the customers table). I need for a value from another table (a table named addresses) be placed in a field on my customers form based on the value of the address field in the customers form. For example... I start to enter new customer data, then after I enter...

Lets move on to my end result question in a minute and work on the normalization right now. I, "for the most part" understand normalization, but would have a few questions in my situation. I'll tell you what I have now and what I plan on changing it to and maybe you can assist me along the way...

This one is going to be confusing to explain, but in reality is simpler. I am wondering the correct structure for certain tables regarding customers. I'll start with the end result of what I need. I have a customers form with, amongst general customer data has a service days field and a...