Good Afternoon,
I haven't had much success on here, so I'll try to ask my question as clearly as I can. I have SEVERAL subforms on a main form. The subform return records associated with ...
Hello
I am trying to change the format of a write to file to left justified format with trailing spaces instead of right justified with leading spaces (apparently default)
The below code s...
I have a form with a bunch of text fields that have control source. The form uses a "SELECT * FROM table_name" query. At the top of this form is a listbox. The listbox is used to filter the fo...
Hello Experts,
I found this code on the site. Itworks great, but I need to open the database in another location: "R:\Nutrition\RICA Nutrition Center.mdb"
Thank you for your help.
James
I have a bount textbox on my form, txtMyTextbox.
I would like to change its value using VBA code, and have tried unsuccessfully:
me.txtMyTextbox.Value = "Test"
and
me.txtMyTextBox.Text =...
I use sendobject (acSendNoObject) with no problem in an Access 2007 DB. I am now attempting to email a report using sendobject (acReport). Each time I attempt to run the code from a button i...
I am trying to import a file from Excel into Access via a command button on a form. I keep getting the following error:
Run-time error '3274':
External table is not in the expected format.
...
Hello,
I am trying to automate an Outlook Appointment from Access and having difficulties with the recurrence code. Below is what I have so far and it works - except it creates the appointmen...
Hi Experts,
I am new to Experts Exchange and need help creating a query in MS Access 2003 which inserts a new row in an existing table for ID1, ID2, Start Date, End Date and Quarter End Dat...
Hi,
I have a database system I'm going to be releasing in my organisation and i need to make sure that certain reference are set at the startup so that certain modules will work correctly. ...
Hello, thanks for reading.
I'm trying to incorporate an HTML editing form in to my database, I'm using Stephen Lebans' editing form which uses the Microsoft Web Browser control to edit the ...
Hello,
On a form I have two text boxes that contain time values, the text boxes are formatted
as Long Time.
Text114 is the system time. JETime is a time stamp.
I need to convert these two ...
I'm working on an MS Access application that cycles through email addresses and sends an email w/attachments using the CDO message handler.
It works great for email addresses on the local ser...
A 'black' highlight appears over the activated task as as shown. This highlight does not appear when the task is first entered (newly activated). I would like to avoid the black text highlig...
I have imported an outlook 2007 contacts list into Access. I want to use the categories field to query on.
Many contacts have more than one category. There is only one category field so al...
Hi
This is probably very simple, but I can't find the answer anywhere.
Is there any way that I can prevent a user from deleting or adding records while allowing them to edit records, pre...
What is the differences, advantages, and disadvantages between Me.Undo and RunCommand acCmdUndo? I'm using both in my code.
We have this database created when everyone had Office 2003 or earlier installed on their computers. The code snippet that I pasted was found on this site, and modified for our use and worked...
I have a Listobx on a form (Form_A) that is populated by Table_A
There is a button on the same Form_A to Add a record to Table_A.
-CLicking on the "Add" button opens a new form ...
Hi,
I am trying to adapt the audit trail function from the Northwinds database that is on the Customer Details form. This memo field is bound to the Updates field in the Customers table.
...
I have created a datasheet in Access 2007 for a client. He wants to filter data using the built-in text/number filters on the column headers of the datasheet. Whatever final result is reache...
Hi Experts,
I am conveting a access 2003 database to access 2007 and getting a lot of compile errors. I have fixed a few of the missing libraries and most seem to be ok. On the below sub I...
Hi - I have an field on a form named "Image." I'd like to place a browse button beside this button that will enable a user to navigate/find an image on the computer'd hard drive. Then, I'd l...
I have an app that I am converting from Access 2003 to Access 2007. It has a main form with a few sub forms. On one particular sub form, when I click one particular button, I get the error "...
I have a recordset based on SQL connecting to AS400. How can I COPY that recordset to a real Access table without having to read/write each field/record? Anything similar to COPYRECORDSET in...
