Hi,
Can EE give me some examples? Thanks
I am running the following Update query:
UPDATE RejectSub SET RejectSub.ValidValue = "Y"
WHERE ((([RejectSub]![UID])=[Forms]![Form3]![Form4]![PostReFlowSub1]![UID]));
Please notice the ...
I'm working with calendar data exported from Outlook. For some reason, Outlook exports the data as text, not a date/time variable, so I need to convert the data to date/time before I can work...
Access documentation seems very poor in regard to SQL SELECT. Can someone explain the use of EXISTS in a WHERE clause?
Hello!
I need someone to help me with the code on how to open a file browser dialog box that can be used to select more than one ".xls" file. Similar to the one used in Outlook when selecti...
I know I have seen other posts on here, but I'm looking from as simple as possible:
I'm trying to go thorugh a text file line by line, parse the line into seperate variables, then insert th...
I've a issue where the columns stores the date, starttime and end time in PST time zone. I want to add another column (computed if possible) and convert the date/time to IST. Is this possible?...
Hello all,
I have a database in Access .mdb and would like to convert it to a .exe
1 possible way would be to use Office Developer but it seems like Microsoft has discontinued the produc...
I have an MS Access application where I send an email out to a customer using Vba code. I use DoCmd.SendObject to email a customer the information.
Everytime I send out an email I get a ...
Hi,
I need some advanced help on importing Excel-files into an Access database.
Consider the following:
- I have a VB program that allows users to import their own Excel files into our fi...
This should be easy. I'm trying to declare several global variables that will be available to every form in my database. After searching the internet, and through trial and error, I am pret...
I would like to know the limitations of access in terms of
1. how many rows it can process
2. how many column it can process
3. what is the best solution if your database exceeds the limi...
I need to remove leading zeroes from the following types of text strings. I'm looking for the shortest, fastest way of converting this field. I'll be using setvalue to post these to another ...
How to find a substring in a string in SQL query condition where the substring does not have a fixed postition in the string.
what function should I use
Dear all,
I am having the following erorr:
The Microsoft Jet database engine could not find the object 'Databases'. Make sure the object exists and that you spell its name and the path ...
What I would like to do is use 2 DAO recordset2, as below,
Dim db1 As DAO.Database
Dim rs1 As DAO.Recordset
Dim qdf1 As QueryDef
Set db1 = CurrentDb()
Set qdf1 = db1.CreateQueryDef("")
...
Error Message: The instruction at ... referenced memory at ... The memory could not be "read."
This is happening in an Access97 database on Windows NT. Here is a list of what has happened a...
Hi,
Is there a way to open a password protected Word dopcument if the
password is forgotten ??
I know this is a Access area but I have no idea where to post this question.
Any help ...
I have this code to audit some Excel files...
Dim FSO As Object
Set FSO = CreateObject("Scripting.FileSystemObject")
Dim Fl As Object
strFolder = "P:\..."
strfile ...
My computer has short date format dd/mm/yyyy in Regional settings. Suppose I write SQL query:
INSERT INTO Dates ( Date1 ) VALUES ('01/02/2007');
01/02/2007 means February 1, 2007.
What happ...
Access 2007. I have just migrated to this. How do I do a Compact and Repair of my db. Can someone give mt the steps.? thanks.
I know how to do this via SQL, but not VBA.
I wish to be able to delete a table and then create a new table via VBA. Can this be done or do I need to call in a delete table / make table quer...
Hey Experts
I've been forced to use MS Access (usually use MS SQL). Now I need to Average (AVG) a Field (type text 10)
Here is my SQL.
SELECT AVG([cmi-core-score-raw]) AS [average],...
i need to create a button that imports an excel file as a table, asks for the location of the file to import, checks if the colum "Discount" is not null (and if null puts a zero as a value) an...
Hi all,
I'm having problems exporting data to Excel using VBA. What I need to do is complicated, and well above my skill level, so I hope you can help.
I need to transfer data from a ...
