Search results

thanks the after update suggestion worked great.

hello, I have a field on a form [vin] that is based on a table, except i changed control source to a Dlookup to pull the vin number in from another table so i wont have to type it when i enter the record. However, this field is not saving when i save the record. I cannot just make a...

I am sure there was a more efficient way to do this, but for anyone having the same issue, I have to on each of the five 3rd level subforms, OnOpen gotorecord, last, one i did that the values appeared in the blank textboxes.

Hello all, I have attached a jpeg of my issue to explain better, i must not be understanding subform control correctly (despite the standard http://access.mvps.org/ link). I have a series of subforms that run (they are the third level subforms off the main form). i have 6 text boxes on the...

The DateValue worked great, thanks so much!

Hello, i have a query that pulls a read-only SQL table, i have check in that table and the date field is set up as a Date/Time type, however the db was set up with the date and time in the same field. (1/1/2014 9:00:00 AM) I have set up the SQL code below to pull out just the Date and not...

Thanks CJ i will give the two separate searches and combining them a go.

hi, i have a read-only link into a SQL db from Access that holds all of our ride records. in that db the designer has a tblRides that maxed out at 1.2 million records, so he had to create a tblRides2 table. All of the fields are identical and the ID in each respective table starts at 1. i...

the subform txt located in the footer is txtCount and the ctrlsource is =Count([Last Name]) running the subform alone it does calc correctly. then on the main form txtTotal is the control name and then on click of a command button i have Me.txtTotal.ControlSource = "=[DriversAll...

hi, i have a subform with a textbox in the footer to count[id]. then on my main form i have another textbox that has a control source of =[subform].[form]![subformfootercontrol]. however when the subform updates the main form text is blank. typically i see a ?#Name or#Error if the control is...

Hello, I have a form that has five subforms on it. On Open all the subforms are unbound (so i can prevent the queries from running before the On Open event to speed up). Then i can enter my criteria for all five subforms in txtbox and click run. After I establish the source object for the...

I am having a little trouble with the path, do i have to reference the main form and all subforms?

Thanks I will give that a shot.

Hello all, i have a main navigation form and my question is: Is there a way that when i am looking a a query or entering data onto a form, that when i switch to another navigation button and then come back to the first navigation button,that the form and query does not reset, so you can view...

Yes the data entry mode is ok, I can enter a record if a reallocated record has never been entered for the specific van, i just cannot get it to give me an option for a new entry with the relationship fields entered in the new record. I think it may have to do with using 2 PK in the query...

Hello, i have a form that has a cbx that controls two queries, a van profile and a reallocation query. I have buttons that switch each query visible.true/false depending on what i need to see. when i go to the allocation query (which defaults form view) the query pulls in some basic van info...

thanks so much for the tips plog

I appreciate the help plog. I cannot post the DB due to security at work, but i think i would need a: Vehicles* [ID] - Autonumber [Van #] [etc details make, vin....] [Reallocated] checkbox (this would just be to indicate there is a log in the Reallocate table??? [Status]...

I thought of that, however i know the vehicles and the Retired tables would only have one entry per van, so i made the PK the vin numbers on those tables. but the reallocated table needs to become more of a log, as in theory we could move the location of the vehicle to 100 different clinics...

Hi, I have three tables: Vehicles; Vehicle Reallocated; and Vehicles Retired. I have a form that runs a query to find all the info in the Vehicles tbl that is not "Retired", not visible in the form. I then have the option to toggle to a Reallocated or Retired form. When i toggle to the...