Description:
Microsoft Office Access newsgroup.
|
|
|
Memo Field needs to include field name within field.
|
| |
I need to add a memo field into a report and I need to have the data preceded by Note:. I used the expression "Note:"&" "&[Note] and now it appears I have a text field not a memo field. What is the best fix for this?
|
|
|
DoCmd.TransferText Method combines header into one
|
| |
I'm running a straight and simple TransferText method and getting an error: Run-time error '2391': Field 'RequestID_PartID_UnitNum' doesn't exist in destination table 'RequestPart' The code is such: DoCmd.TransferText acImportDelim, , "RequestPart", "C:\importrequestpart.txt", True importrequestpart.txt is a tab delimited file with a header row (3 columns).... more »
|
|
|
Generate string from selected checkboxes on continuous form
|
| |
I have a continuous form with a bound checkbox ("ExportSelect") on each line. I would like to have a command button on the form footer with an onClick event that finds all the records with checked checkboxes. Each time a checkbox is true I'd like the string to add to itself the value of another field on that record....... more »
|
|
|
döner
|
| |
ja döner macht schöner
|
|
|
Calculations on Option Group
|
| |
What I'm trying to do seems like it should be easy, but I've been banging my head against the wall for 2 days now and still can't figure it out. I have an option group with 6 selections, stored as 1-6. I want to run a summary function on these within date parameters and display a separate count for each of the 6 options. I've tried executing this with a SQL query, a... more »
|
|
|
Access 2007 options group
|
| |
I have an access 2007 application with a form with an unbound options group with three option buttons and the labels that go with each option. You know how when you select a certian option there is a dotted line box around the text of the label, on mine sometimes the dotted line box shows around 2 options (sometimes not).... more »
|
|
|
access2007 option group dotted line box around text
|
| |
I have an access 2007 application with a form with a unbound option box with three option buttons and labels. When I select them sometimes the dotted box shows around 2 of the labels. The options have values 1, 2 and 3. Not sure why it is not just showing the dotted line box around the selected... more »
|
|
|
photo on a form
|
| |
I am asked to create a database that has employee info. When it is finished they want to be able to query the employee's name and bring up that info in an easy to read form. I can do that, but they also want a photo of the employee to appear in the form for verification. I have no idea how the make the photo thing work or if it is even possible.... more »
|
|
|
delete from many tables at the same time
|
| |
Hi I am new using Access, and this may be an elemental question, but anyway, I have three tables: Customers. Orders. Payments. (Customers' payments) Customers has as primary key the name of the customer and the other two tables have as a primary key an automatic ID integer. How can I configure Access in the way that If I erase a Customer from the... more »
|
|
|
|
