I have very little front-end dev. experience & I'm creating a Call Tracking data entry form. I would like to search by several columns, including LAST_NAME and ID but never more than one column at a time. I have a form and a subform.
What I would like the user to do is open the (blank) form...
I have a report grouping on OFFICE_NUMBER with data displaying after the grouping. This report is actually a letter and I need a new page for each set of data. I have all the text in place but the 'details' section of the report, where all my data is displaying, is breaking the data into...
Ahhhh...so you need the least normalized! Sorry, I don't know how to help you and I can't think of a good resource since you are, in reality, breaking all the rules. I'll ask around to see if anyone can help.
Good luck!!! I'll keep my eye out for an answer for you.
Is there any reason you have duplicate data to start with? There may be something I'm not understanding but one of the fundamentals in db design/normalization is to not store the same information more than once so as to avoid this kind of situation. I'm not sure how to fix it except to avoid...
I'm trying to Transfer Text using a Macro in Access 2002. The Macro worked fine in Access 2000 but yesterday I upgraded(?) to 2002, converted my db and now I get the following error:
Cannot Update: Database or Object is Read-Only
The read-only attribute is not checked for the database and I...
I'm working with a Sybase table (through Access) which stores phone numbers as Text(25) formated as (XXX)XXX-XXXX. I need to change this to be XXX-XXX-XXXX for an export to another db. Formatting won't work since it won't know what to drop, I figure I should parse it but don't know how to do...
I'm using the following IIF statment in an Update query. The idea is to compare 2 dates (short date) in one table and insert a value into a third column in that same table.
It is not giving me errors but is inserting all 'C' values. The table only has 27 rows in it right now so I can easily...
When using the Meeting Request Form to invite attendees to a meeting the message is sent as a regular email. I don't know too much about Outlook set-up but I believe we are not using an Exchange Server...is this required for meetings?
Creating a Macro may not be the answer. I faced this problem previously (using Access97). Sending the email worked from some machines but didn't from others, regardless of whether Outlook was open. We compared all settings and couldn't find the answers. This was never resolved, please post...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.