Hi,
Can EE give me some examples? Thanks
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?...
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...
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...
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...
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...
Access documentation seems very poor in regard to SQL SELECT. Can someone explain the use of EXISTS in a WHERE clause?
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...
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
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 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,
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 ...
We have this old Access app that REQUIRES the 2003 runtime and doesn't run correctly under 2007. The app can't be updated, either. So, we need to find a download of the 2003 runtime. Does a...
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 ...
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 ...
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 ...
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 want to drop a Foreign Key constraint in MS Access but if it doesn't exist I get an error (CHECK constraint 'FK_MemberFamily' does not exist.). Fair enough. Therefore I want to check if it...
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...
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("")
...
Hi All,
This should be an easy one, but I'm running out of time and need this asap. I need to download the Microsoft Access ODBC Driver so that I can set up a User DSN that my Java program...
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...
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],...
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...
