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...
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...
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...
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?
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'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...
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 ...
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 ...
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 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...
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("")
...
Greetings,
I am developing a Delphi apllication and need to import both CSV (comma separated) and SDF (fixed lenght) files into an Access database.
Lets say that the Access database is DB1...
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...
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...
Hi i'm an asp newbie and am just trying to insert some data into a database table.
i can successfully retrieve data but it wont let me insert.
my code is below, if you have any questions...
hey guys
basically i'm near completion of my project. its due in on thursday and i want to add a fgew "killer applications" (as i like to call them!) to the project - your know a few bells...
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 ...
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],...
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.
