I have a database and one column is all CAPS....I have entered a format mask that has changed the CAPS to all lowercase
BUT now I want to capitalize the first letter to make it formatted co...
On my First Form I have Industry(Text) and IndustrySector(combobox) from tblIndustry
A Subform having SubSector(combobox) and Process(combobox) Linked with IndustryId (tblIndustry) and Indust...
Greetings, Experts!
I have been given the challenge of creating a solution in my company's Access DB's (MDB's) to dynamically move whole folders (with files in them) from one location on ...
The recordset.open method returns an error. The object MyTable_New is not recognized. There is no error when the tablename is MyTableNew.
Here is the scenario:
dim cn as adodb.connection...
Dear,
I made a program where I am connecting a mdb file with adoconnections and adotables and queries.
On my laptop I can run the program and there are no problems.
I am connecting the a...
I'm writing an application in Access 2003 that prints customer-specific pricelists. I have a simple form that asks the user to enter the customer ID and select the product category or categor...
OK. I know nothing about Access database, replication. But my searching today makes it look like it was an Access 97 thing that is now extinct?
I found a wizard tool on Microsoft's websit...
this code doesn't work
i'm guessing my if statement is missing some syntax
Public Function WhatCatComIsIt(ByVal comboCommodity As String, ByVal comboCategory As String) As String
If ...
I'm trying to figure out how to programmatically export data from Access to Excel, create a chart in Excel and then copy that to Word. I've been performing this operation manually and It's no...
Hi
Im attempting to create a query where the source data is from a linked spreadsheet. I need to append this to a database table but obviously do not want to include records already in the ...
I have a question about inner joins. By using a lookup table and a row function, I have the following question and code. I am not sure if it right or not. I would appreciate any assistance:
...
I converted my access database from 2000 to 2003
Trying so call a small subform using the following command
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, acMenuVer70
Run-Time...
My db has about 50 tables linked via ODBC into the db.
Forms are populated via SQL-Selects in the datasource property.
This works all fine until today where one Subform pops a message the an...
Hello;
How do I copy the contents of one folder to another folder via VBA in access through a module and be able to execute that module from a macro?
Thanks
I have a listbox containing "Descriptions" of attachments that have been added. (Don't worry, only storing path). I also have command buttons for the following: Open File, Attach New File, Ren...
I have an access database that imports an excel spread sheet. I need to do the same thing for another appication but this time there are multiple worksheets in the spreadsheet. I need to kno...
Does anyone have or know where to get example code specifically for Access 2000 on using distiller. Any good web tutorials or references. I was able to find an API reference for it and some ...
I can't seem to get my head around how to do this in a query or series of queries in Access. I am extracting some data and I need to show the weekly average price and a season to date average...
Hi,
I am faced with a scenario in finding an employee's salary increase, both in dollars and as a percentage of the previous salary. Calculate how long the employee had towait for that increa...
Hi Experts,
I have 1 query that extracts e-mail addresses from clients that have made a booking, in order to e-mail them for their feedback:
SELECT First(Clients.Lead_Name) AS FirstOfLead_...
Hi all,
Ive been trying to get the old DOS dir function to be presented in a list box in ms access. That way when I click on it in the list box I can set follow hyperlink to the specified ...
I have a form (Form1) with a button, ID field and a checkbox field(me.mrb).
I coded the button so if the check box is equal to 0 it will open a different form (Form1) showing all the recor...
While working on a database, I somehow deleted my main menu toolbar. I'm able to turn it back on if I run VBA code, but it won't save the changes if I exit out of Access. The Menu Bar is mark...
I am pulling a large amount of information and I am trying to dump them into a new table. However now it seems that once it goes for a while and fails it gives me an Invalid Argument error. Af...
I have a pre-saved static MS Access Report that I am Opening through a Form in MS Access. The User has two options from my Form. Option 1) Simply Open the Saved Report by selecting the Report...
