I have a MS Access 2003 form with a label named 'lblTrackingHyperlinkNumber'. The label's caption is the Tracking Number from the United States Postal Service. What is the label's hyperlink ...
Hi
I have two variables oTable, oField and oID
How do I write VBA code to find the record containing oID for field oField intable oTable
and open the table with that record selected
...
I have a problem when I am trying to display crosstab query on Access form, I send parameters as date and I suppose to populete the form with these result, but I got this error
You can't us...
I need to find code that will create a reference to another Access DB which contains generic code used throughout several other company applications. All of our user's applications are shared...
I have an application that links to sql tables using ODBC. The users access all the same tables but one group access them from one server and another set of users access from another server. ...
Is there a way to bind an unbound text box in a continuous form to a record set? I want to be able to enter different values in the text box in the continuous form and then send the values t...
Hello Everyone,
I am trying to write a code that will import an excel file with multiple worksheets called "Planogram_Data" which resides in "C:\Super_Import\Planogram_Data.xls". I would l...
I'm trying to get the next row in a query.. for example
ID Value GetNextRowValue
1 3 2
1 2 6
1 6 8
2 8 0...
Is it possible from within a query to call a function or a sub that would return several values into multiple columns.
I only want to call the query and function/sub once. but the results ar...
OKay.. so I'm using VBA automation from an Access script to generate an outlook e-mail. However, I'd like to embed images in the email... (not as an attachment) (CID?)
Now I thought that i...
I get several excel files each month that I need to extract data from and put into Access:
Source folder = S:\NYC Reports\- Working Reports Folder\Inventory SWIP\Data_from_NFTS\Raw
Each work...
The form has one sub form. The focus is on the sub form, I need to move the focus to a list control on the main form, select the first entry and activate, this then refeshes the sub form.
Al...
Hi :)
I know this has been asked before, but I've been unable to find a satisfactory answer. I have a subform viewed as Continuous. The subform contains a memo field. I need the field to...
Hi All,
I have a small access application developed in Access 2007. Every time I run it on a machine that has no access but just the run time files(downloaded from Microsoft site) it pops up...
I have a listbox with 3 columns. I want to populate all 3 columns from a recordset.
I have the following code which works.. but only for one column.
i have fields - proj_id , wbs_short...
I have successfully created a Linked Server on Microsoft SQL Server Express 2005 with the following:
Server is at 192.168.0.106\sqlexpress
sp_addlinkedserver @server = 'LEDGERS',
@srvprod...
I am querying a website which returns data to a new sheet in my MS Excel workbook.
I am placing this data into the sheet via QueryTables.
One column of results from the query returns langu...
The field contains characters that I think are carriage returns. The character looks like a square. I cannot do a Find and Replace. I'm able to highlight and copy the character into notepad...
Hi Experts,
In my current procedures, I will pop up a form using DoCmd.OpenForm "FormName". This form constitutes several text boxes that I need the user to fill in the required information...
Looking for a "can it be done?" answer, not really how to do it at this point. I have a complicated Excel Workbook that feeds a report (lots of graphs). I am moderately confident with Excel, b...
Hi
I am trying to change IIf([Contacts].[APC]='XXXXX','Deleted','')in this query but don't know to change is SQL as db is transfering to SQL
here's Query
criteria = "SELECT Contacts.C...
As I add VBA code to an Access 2003 module - I find myself hand-typing the following code often: Is there anyway I may automate this and if so, how? I am unable to buy the add-ins the market...
We have a runtime application that has been distributed to many users. We have a new user who is running our software, runtime in Access 2002 on Windows XP Pro. When the program opens the fi...
User needs option of inputing a Canadian postal code or US zip code in the postal code field. The mask must allow either type of code but prevent any errors. Application is for small busines...
Is there a VBA command equivalent to a user hitting the Esc key?
