I have a list box that is plugged into a table with that only has one field, it is a hyperlink field.
I want to give the user the option of adding a new hyperlink to the listbox. Which m...
I have table of events.Each event has a start date and end date field. I want to list in a query all the days that event occurs on with the event number.
eg for 1 record where event No. i...
I have the following code. Can anyone tell me why it doesn't work? I have a table called myTable and there is one field called aField and only one value (of number type) under this field, whic...
Hello I am trying to run my macro in my excel spreadsheet after I open it from Access. My code is in the personal.xls speadsheet that opens. The export always overwrites (deletes) the old fi...
What VB would I use to make the listbox value = the current selection - 1.
i.e. My listbox shows the following.
Custard Condiments
Ketchup Condiments
Beans Vegetable...
How can I use "Weekday" function to run a procedure daily? I have it the table built, but I need the coding to make it run every day.
Right now I can get it to run on a single weekday only...
Hi, I have an Access DB that contains a list of individuals (agents). I also have a folder that contains Excel Spreadsheets with a file name exactly the same as the agent name in the Access D...
Hi,
Some time a go I wrote a routine to create and join to TEXT files so that the file could be imported into our Unified messaging system. Basically it is a Header (4TobitImport.txt) join...
Hi experts,
I have a custom dialog box that I use to get input from the user. In this case, I ask the user to provide a ticker, which is a four letter alpha string. I need to make sure that...
I am trying to figure out how to gain access to the bookmark array with the code below. It keeps giving me an error (Wrong number of arguments or invalid property assignement) and I know it i...
I have a query that pulls the last record entered for an order number from one table, based on entering an order number in an MS Access form, and i want to update the row in another table wit...
Have the below sub assigned to a button on a form in Access. It runs but am having some issues with it.
1. Is there any way that I can pass parameters with this command to the query? I w...
I am having a problem trying to do something very simple. I need to program a little bit of function based on a field that is populated. What I am trying to do is
If txtasweightplan = 50...
Hi
I truly hope someone can help me with this one. I have spent hours trying to diagnose what the problem is without success and am desparate for a steer.
I am having a major issue with ...
Hi experts,
I'm writing a procedure using VBA in Access. What I want is to select the records from a table with such condition that the values in a specified field do not equal to any of th...
I'm trying to launch Outlook from a form within Access, can can't get the VBA code right.
Also, I'm trying to open the calendar and tasks in new windows.
Here is some sample code I was inv...
I have a fairly complex form that I would like to create in VBA. In essence this form will be utilized to run a query. This form is made up of 5 list boxes, labeled List0, List1, List2, List...
From a previous question (Relink access table), I received the code below where 2 functions are missing.
ahtAddFilerItem and ahtCommonFileOpenSave
Where can I find the code for those fun...
Hi, I'm importing text data from a supplier. The first 4 records contain text information that I don't need, but the supplier is unable to remove them. This puts text data into the first fou...
I have 2 users. Each have a copy of my Access.mdb on their own computer that uses linked tables. The linked tables are in another Access.mdb elsewhere.
If both Users have my Access.mdb ope...
Is there a function to check/enforce that a string is a valid Windows filename?
I am generating an Excel spreadsheet via OLE automation and the filename is based upon the customer name as e...
I have a table where I want to concantenate multiple fields and separate each of them by a comma. The only issue is that some rows have for example 3 fields, and some have 5. See example bel...
Okay, Experts, here's my latest conundrum:
I cannot seem to set a validation for a column in an Excel spreadsheet from Access. This file is being programmatically created from Access durin...
Our company policy allows duplicate records to be created. Each duplicate record is expected to increment by 1 and grouped by the entire like operant preceding alphanumeric
for example - 200...
PIPE INVENTORY TABLE
===================
Pipe ID
ASL #
...Other Pipe ID Details
Two peices of Pipe are welded together and the information is stored....
DOUBLE JOINT TABLE
=========...
