Search results

ok still having trouble . and i think its relationships.. the vehicleid field doesnt show 1 to 1.. when i pull up the cmd button to open frm equip, i get 3 vehicles. but equip all the same

thanks, i have been working on it all day and not getting it right.

ok, i had to change the code a little [to get correct name of vehilceID field]- but now form opens, no more compiling error -- BUT i am not getting the right record. i 'think' my relationships are ok? my [vehicleid] field on the frmequip page is not populating.. i think that is why.? when i try...

ok i re read and think i did what you advised me.. but i get a compile error. not sure what needs to be changed, i copied and pasted. i am including a copy of db... this one has the changes you suggested, disregard teh one from earlier. ... thanks

ok i just re-read your post. the code should go in command button.. so my question is where should i set the default : [vehicleid]=[Forms]![frmvehicles]![vehicleid] or should it be: [vehicleid]=[Forms]![frmequip]![vehicleid]

ok i am stuck. on the button to open equip, i have an embedded macro to open the form where: "[vehicleid]=[Forms]![frmequip]![vehicleid]" but when i click on button nothing happens. can u help me with this ?

thanks for input. will try that. i do have a question/ favor to ask. i noticed fri my computer on 2003 was crashing. i have access 2003 and 2007 on my computer, i am in process of switching everyone over to 2007 but havent gotten them all yet. i created a new db, imported the tables, queries...

I am trying to set up a vehicle inv file [access 2003 db but using access 2007]--the tblvehicles includes info about a particular car, the tblequip which is linked by an equipid decribes detailed equipment about that car. My problem is that somehow i must have the relationships screwy... when i...

ok, after some more research via google and the forum, i have raised some other questions. My table is a vehicle info table, including vehicle make, model, year, submodel, miles, color, blue book value, and also including [for ex] sold (y/n), sold date, sold notes, uw (y/n), uw date, uw notes...

i have a table that is called "vehicleinfo"/ in that i have some fields that i want to split off from the vehicle info table. they include sold, sold date, seller, sold notes. i want to make 2 talbes. I can use the table analyser to split one by one diff tables for other items, but for some...

ok i have tried splitting tables individually, instead of all i want to do at once, most work, but one of them isnt. how can i split using queries, and will it split the data into 2 tables? so the program runs faster? i am not sure exactly what you mean.

because i dont want to just add records, but split 1 table into a few seperate tables.

i am trying to use table analyzer to split one large table into some smaller tables for efficiency and to speed up the data base. the data base tables have grown over the years as business has, and not in the most efficient manner.

I am trying to take an old, sad out of shape datea base, with about 98k records, [on access 2003] and clean it up using table analyzer. I keep getting this error "file sharing lock count exeeded, increase maxlocksperfile registry". I found the instructions to do this, and changed the registry...

i was trying to analyze tables in an old / outdated database.. in access 2003 and got the same error ..... i tried what you mentioned.. but still got same error. any other ideas? i want to streamline some of the tables so i can update.. but want to save the query and it wotn let me. we have...

I am trying the conditional formatting, but i cant seem to get the right expression to do what i needed , i tried: [cboagent]= like "*" & "need agt" & "*" but that gave me a synax error-- any ideas on where the expression is wrong? thats the expression i use to generrate reports with the...

field is in a single view form

Is there a command or code that will produce different color font if the field contains certain criteria? For instance, if the AgentID field contains the words anywhere in there "NEED AGT" then the form will display that field writing in red? to stand out? I tried to play with some commands but...

I have a question. will this work as well to cover a combo box? say if a new record show the combo, if not a new record show text box? i know shouldnt matter, but i am importing from another data base and cant get a city field to show.. thought this mgiht be a quick fix.

buttons and everything work great. i havent dont much more than test it. will work on it tonight see if rest is all ok....