Search results

I've tried to go the insert method but get a error expected end of statement. I'm just trying a few simply fields before I work on dates and cash. It highlights the word vrcfines INSERT INTO vrcfines ([ubl][name]) VALUES (vrcedit!txtubl), (vrcedit!txtname) *10/10/09 problem resolved, I...

I need help to append a record to a table from an append query based on the fields there not equal to Combined(ubl(text10),complaintid(numberlong int),finedate(shortdate)), I cant seem to get the logic right without getting a data type mismatch...access2003. Append this forms record to that...

Hey Bob, So I told the boss my problem and he looked at me with a strange look and said what? lol...I enabled the field so they can cut and paste for the time being. Do you think its possbile to get the memo to memo via a qry/form? Thanks, Ray, is it me our is the site slow this week, I thought...

Hey Bob, Is it me or is this server so slow this week. So do you have any other ideas on how to transfer the memo field info to complaint file via a query/form? I told the boss the problem and he kinda looked at me, like what? lol, I gave them access to copy and paste the rule for the time...

I have a memo field on a form which will have data from another table placed in my field, but it only displays the first 255 characters from the table, my form field is also a memo field. Access 2003. These are both table fields and are memo fields. I use a replace command on the form to take...

I have a memo field on a form which will have data from another table placed in my field, but it only displays the first 255 characters from the table, my form field is also a memo field. Access 2003. These are both table fields and are memo fields. I use a replace command on the form to take...

The qry is getting all the text needed just not adding it, I added the word arnold to tell me where I was in text count. qryrules2 DESCRIPTIONAll pets must be physically leashed when outside of the home or fence or enclosure and shall not be permitted to run loose. No more than two pets, not...

corrected, same result 255 characters exactly...Ray qryrules SELECT RULES.VIOLATIONID, RULES.RULECATEGORY, RULES.VIOLATIONOF, RULES.QUOTEDARTICLE FROM RULES ORDER BY RULES.RULECATEGORY; qryrules2 SELECT qryrules.VIOLATIONID, qryrules.RULECATEGORY, qryrules.VIOLATIONOF, qryrules.QUOTEDARTICLE...

Bob, qryrules is the 1st without the memo field, description, This is qryrules2 adding the field from the table, rules. same result, see anything or did I read your note wrong? Thanks. Ray SELECT qryrules.VIOLATIONID, qryrules.RULECATEGORY, RULES.DESCRIPTION, qryrules.VIOLATIONOF...

Hi Bob, I read thru that and I've got no format issues anywhere they ask. I am trying to input from a query so I'm guessing the only work around is doing that append it to another table and then import it, is that your solution too? It seems like alot to do alittle. To answer the questions why...

I have a memo field on a form which will have data from another table placed in my field, but it only displays the first 255 characters from the table, my form field is also a memo field. Access 2003. These are both table fields and are memo fields. I use a replace command on the form to take...

oops, found it...I was using Description.... Change a field's caption Open a query in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and...

I'm looking for a way to change the heading names in a query, I have one field called complaintid but is only a 2 number field, I'd like it to read CID at the top so I can resize it. Thanks for all your help especially Bob. Ray

If I want to use data (display only) from two tables, I have a relation on the two, do I have to use a query? I can't seem to see the other table fields or find how to open another table for the form. Ray

Thanks, This is the reason. Residents is a table that usually changes weekly, owners in a home owners Assocaitions. visitorlog is a table of people who come thru the gate as visitors telling us they are going to an address. vrc is a violation table. When security radars a car speeding or parking...

I find myself having to make a new query for each form I make because the (where) is a different form name, can/is there a way for anyform[same field name on different forms] be used? Is that a valid statement? anyform? Ray

I run this query from a form and it adds a record with all the information needed from the residents file, but I also want to take information from the forms source table, visitorlog and put it in the vrc table. When I try any field data it wants to add the the total rows of the visitorlog...

you got it gemma, I had a field called date, changed and all works like a charm, good tip..Thanks alot. Ray

2003 access, I've used date() in append qry before and that works but not in a form afterupdate. I'll check out steeles link and see what that does for me. Thanks for the replies. Ray

Thanks, this is what that code gives me...? Dim myDate As Date ' declare a local variable of the Date data type *myDate = Date ' assign the current date to the variable MsgBox myDate 'show in a message box *error invalid use of null