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 ...
My understanding is that a list box allows multiple selections but a combo box allows just one selection. For reasons of space I want a list box that has drop-down functionality. The Access 20...
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...
Hi Experts,
I'm using a Access 2003 ADP front end into SQL Server 2005.
I have successfully created a temporary table (#tblTemp) in the server using VB from within the Access app and it ...
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...
Do you know how index_of/substring or InstrRev works in plain Access SQL ??
I need to extract from this string - "P_80000463_194802" two sections:
1. "P_80000463"
2. "194802 "
Can any...
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...
Could this error mean that the user has never opened access before and therefore has not started a system.mdw file? Please let me know.
I have a database - back end sql, front end acces data project. I want to add 60 days to the now field:
(dbo.tbdProject.ContractExp >= { fn NOW() })
Thanks
I've been researching this problem on this site and see many others have experienced it. I think I'm dead in the water, but wanted to ping you guys to make sure before going to a (very old) b...
This has been asked a few times and I've seen no generic solutions so here is a function to retrieve and display the row number in a query:
Function GetRowNum(strQueryName As String, strIDF...
I have an Access 2003 database for our Help Desk. I have several tables, one of which only has 2 fields, Caller's Name and Phone Number. So I'm building a form for data entry of each call.
...
I feel silly even asking the question, but how do you hide and unhide forms from the user interface in Access 2007?
In Access 2003 and earlier, when I had an open form I could go to Windo...
Hi Experts,
I have a database that needs to be open to multiple users. Currently when it is opened by one user it creates a Lock File. The main window is a form that allows record searchin...
I have two identical tables - I need to Delete the records in the 'Data' table that are identical to whole record (all the fields) in the Data_Intermediate table
The Tables:
Data:
Date...
Hi,
I know that this has been asked before but I want some code to create an inputbox in MS Access that has a password character * in it rather than displaying the text.
I know this is ...
i would like to populate a listbox with values stored inother listbox ... in a way simular to the way a wizard allows you to choose what fields from a table you want on a form/report ... excep...
When running the below code, it successfully creates a pdf file from the report, but I receive the following error when it attempts to attach the pdf file as an Outlook attachment:
"Can't f...
I have a number pad on screen using VBA Access 2003 with Sql Server
I click one of the buttons and a number appears in the text box.Hit a button again and the next number appends to the firs...
I am running Win XP Pro with IIS5.
I have a ASP shopping cart setup (or not) and when i try to write information to the access database i get the following error.
Error Type:
Microsoft ...
Hi,
I have two tables. I need to have a query which says If the ID's in both tables match, set field 1 = True, otherwise if the do not, AND field 1 = Yes, set field 1 = False.
Something l...
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 ...
Good Afternoon,
I am using a Make Table Query to make a new table. The query pulls from a table where the data elements are formated as Number [DataElement] and [DataElement2]
The fi...
I want to count the number of records in a table and store in variable, then run sum code, then get the number of records in the table, then subract from on another.
Dear Experts,
My organisation is currently using Microsoft Access 2000.
We wish to deploy some databases on machines that do not have Access installed using the runtime version capabili...
