Search results for query: *

I have a form it has several text boxes, fields and a subform. it has a parameter that prompts for a SerialNbr. The fields on the form are SerialNbr, cboCartStatus, CartDate, CartID, ServiceID Subform fields: cboCartEvent, CartID, CartEventSubType, CartEventDate The control source for the form...

I am simply trying to update a record. I have 2 forms. One form "Open Forms" and another form "Close Forms". When the user clicks the close form button they are prompted to enter the FileNo that they want to close. Once they enter the FileNo the "Close Forms" form opens up with prefilled text...

I'm good how are you......I don't know what i would do without Forums like this! Well that fixed my problem!!!!!! now i have one other problem. Once the user selects a value and double clicks it. the form closes. I need the list box to be clear again when the user repeats the steps. As it is...

I have some code that uses a table called "Carts" from an Address database. and some of the addresses have units (like Unit A, Unit B, etc) and some doesn't. I need to be able to tell it to go ahead and select it if it doesn't have a unit. I am selecting the address from a list box. And when i...

i have a form that has one textbox called "Street_Name" and a list box called "lstAddresses". I want to be able to type a street name in the text box (and also filter it, eg. when i type in "Ro" or "Rose" it would bring up all streets with those letters like "Rosewood" and list all the streets...

well nope....thought I did. still getting the object variable error. Help intCountTag = DCount("[TagNumber]", "Tag", "[TagNumber]='" & Me.TagNumber & "'") If intCountTag > 0 Then MsgBox ("that Tag Number already exists, this will be a second warning! Go back and check Second Warning...

Thank you so much for your help. I think i've got it working now.

ok that works but after it runs and print the letter it gives an error: Object variable or with block variable not set. What is that about?

ok I'm sorry. I have a table called "Calls" this is where all the data is written once the user enters the info in the form. In this call table is a field called "Tag_ID" which is an auto number field and primary key in another table called "Tag". in this "Tag" table there is a field named...

i have a field Tag_ID which is the TagNumber from another table. So i wasn't sure if i need to use Tag_ID or TagNumber.

I have an access application with forms, tables, etc. I have a form that the user enters data. When the user enters a new record i need it to tell the user if that record already exist or not. if so, give message. if not, add it.