Search results

Hi everyone, I have a situation where, in a query, I need to autofill the column called "Xferd Vendor No" from the column called "Vendor No", where if the data in the Vendor No column changes, then the autofill changes to match. Please see the two attached files. The one called Autofill Raw...

Hello all, I need to create a function that I can launch using a macro that will copy an excel file from one folder to another in the file system. Can anyone help please???

Please help, I have developed a private sub which automatically creates an email when a button is pushed. The code is working well, but I need to insert Carriage Returns in the Body Text of the email just before the word "Please" where it appears in two places. Is this possible? The...

I just want to have a Macro that will copy an excel file from one external folder to another and alter the file name to include the current date. I have exhaused all other searches and cannot find a workable solution. I have seen and tried several examples of code, but nothing seems to work...

Hello all, I have a requirement where I must develope a running sum of quantities in a table using a query where the running sum resets when the Assy_Item changes. Example Output is attached. Please help. I cannot figure this one out.

Hello all, After deploying a new database to several users in Access 2007 Rutime, I discovered that the Zoombox Functionality does not work in runtime. In the access program I have created a form with a Zoombox Button linked to an event procedure as follows: Private Sub ZoomField_Click()...

I am in desperate need of some help here. I have a situation where I must convert data in an existing access database for use in a new database. The existing data has multiple line entries for the same header number, but has not identified each of those line entries with a line number. I...

Need help here. Is there a way to default in the Windows User Logon Name into a field in a form? Thanks in advance to anyone who can help.

Is there any way to create a Zoom Button on a form that will open the Zoom form normally activated by the Ctrl-F2 command while in a text or memo field?

Is there any way to get a line number field in a subform to automatically increment by (1) based on the previous record starting with the number (1)? Any help would be greatly appreciated.:confused:

Is there any way to increase the limit on the number of records that can be listed in a Combo Box on a Form?

I have a situation where I have a ComboBox with a Key (bound) Column called CustomerID, but the ComboBox is designed to sort the data by a Column called CustomerNo. Is there any way to get the ComboBox to automatically filter the data presented in the ComboBox by the CustomerNo Column, rather...

Hello all. I am so frustrated. I have been trying to find a solution to this problem for days. What I am trying to do is default values into a primary table when select a primary key value in another table. Both the primary and secondary table have a field called "Cust_ID". The primary...

Need help creating a DSUM Expression that will summarize quantities in a Domain where the Item is the same in the Item column. The Table being used as the domain contains several items, but I want a Running Sum for each item in the Domain, assuming they are all sorted in order of item and...