Search results

Let me see if I can explain my need. I've been adding a recording to a fines table one record at a time. I enter the fine date (txtfinedate) on the form and an amount (txtfine1) and the append qry copies this data to the fines table. It works ok, what I would like to do is add each record if I...

Thanks, I'll try this..Ray

My screen lets the user type in a name to find residents but they want it to be a closer exact. Now if your type James you'll get people with the first name of James included but they just want the last name. The field is last, first. Thanks, Ray Private Sub txtSearchReg_Change() Dim...

Does anyone know how I can add the users name to the field in my table createdby, using their login name. I already add the date/time but would like to capture the user that entered the data. I'm using access2003 with security login. Thanks, Ray

Thanks for the link, it really helped...Ray

2003 access, using security. I've read the setup procedures but have a problem editing forms when other users are in the database. I can edit tables or qrys but when I want to edit a form it wont allow me to save the changes and the form is not being used by any users, in fact all forms return...

Thanks, found it, worked good. I appreciate the help. Ray

I need to update bills with the checks number, both are called Invnum. To match the checks to the bills I use the vendor, the amount,the gl account number and then the date. But some invoices have a date a few days before the check, so I want to use the date mmyyyy and would like to know how to...

That worked perfect, Thanks for your help. Ray

I have a table of vendors but some are missing, I need to go thru each table and find the missing records. Append query seems the way to go but I cannot get it to identify a record from table bcp108 that is not in table Vendors. It wants to add the records I already have there. Hope this is...

Thanks, that worked. Ray

I have a checkbox in a form, chkshipto, to let the user decide to mail the letter to the property address (addr1) or the shipping address (addr2). What is the logic in a checkbox? true/false, yes, no ? = IIF([Forms![vrcedit]![chkshipto]= .T., ADDR2,ADDR1) Thanks, Ray

Hi Bob, I was wondering if you had an oppurtunity to check over this matter and see if you had anymore suggestions, I'm still wanting to use the copy but if that doesn't pan out I need to look at the other solutions. Thanks again, Ray

I changed the query to Dynaset (Inconsistent Updates) and all is good... I'll have to watch this in the future, thanks for your help. Ray

I have a query that wont let me change anything. I have the rights in security, the properties of the qry are nothing diff thatn the others that I can edit. I've punched every button I can think of. access 2003. I can change data in each of the joined tables. Any thoughts? Thanks, Ray...

perfect, thanks... Ray

Can a seperate tab use other data than the default table used to set up the form? I would like to use another tab but the data is a table from a linked database, do I need to use a query combining the two tables fields in order to view data from the new table and still retain the other data on...

Hi, I am adding a complaint to a residents file and I want to quote the rule he broke. That comes from rules. I want to append it to the actual complaint to make sure its a snapshot of the exact wording as it was on that day. The homeowners association has a history of changing rules wording...

Hi bob, Do you know if its possible to append the memo field to my other table? I can't seem to find an clear solutions, but I'll keep hunting. If you have nay other thoughts please let me know. Thanks for your help. Ray

I've tried to go the insert method but get an error expected: end of statement. I'm just trying a few simply fields before I work on dates and cash. It highlights the word(table) vrcfines . Its in a command button, click. 2003access INSERT INTO vrcfines ([ubl][name]) VALUES (vrcedit!txtubl)...