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...
Hi,
Can EE give me some examples? Thanks
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
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?...
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...
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'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...
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 am running the following Update query:
UPDATE RejectSub SET RejectSub.ValidValue = "Y"
WHERE ((([RejectSub]![UID])=[Forms]![Form3]![Form4]![PostReFlowSub1]![UID]));
Please notice the ...
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...
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...
Hello,
In VBA, if I want to base an If statement on two values equaling or not equaling each other, do I do it like this:
If([FORMS]![FORM1]![TEXT1] <> [FORMS]![FORM2]![TEXT2] ) Then
...
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...
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...
One of my clients has several PCs running Office 2007 Pro. Our supplied database is written in Access 2003 for which we provide a run-time licence. This works on all of the machines, but a c...
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.
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...
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...
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 want to pull data only if the field 'Event_Date' has a month and year that matches the current month and year. The "Event_Date" field recieves dates in MM/DD/YYYY format.
SELECT *
FROM ...
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("")
...
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...
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 ...
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 have an Access database (XP) from which I created several Crystal Reports (8.5) because Access would not handle all the fields required for the reports.
I tried using the Wizard only to...
