ms-access

Access: How to pass parameters to report when WHERE clause is embedded in complex SQL

I know the question of how to pass parameters has been asked a while back with the this Previous Stack Overflow question However my situation involves SQL that is a bit more complex and cannot make use of the "where clause" filter available when opening a report. My SQL statement is an aggregate that produces a single row with one field...

How to collect input via a form and pass to report query in Access

I have an Access 2003 MDB where I would like to present a small form for the user to input two parameters "Start Date" and "End Date". Thanks to another Stack Overflow user ("Kevin Ross"), I learned how to embed the form control directly in the query that is used by the report I would like to display. SELECT q1.CasesAssigned, q2.Warning...

is it possible to mimic the functionality of ms-access with c#?

i have a split front-end and back-end access database. i am planning to move it into sql server. the front end will be c# linq to sql. question: is it going to be possible to have multiple users use this c# front end and for example be able to edit a table at the same time? you know that ms-access you can design a form with a table on i...

Is there a way to autofill Excel cells with data from an Access Database?

Basically I have a lot of historical data, consisting of IPs, Contacts, and various other fields. Originally we kept all this data in an Excel spreadsheet. I recently created an Access Database with this historical data. Now I am wondering if there is any way to use VBA or something else to autofill fields in the Excel spreadsheet using ...

how to create a xml string and pass it in a stored procedure in ms sql uisng ms access vba?

how to create a xml string and pass it in a stored procedure in ms sql uisng ms access vba? ...

Problem in compacting Access 2007 Database, After Compacting Access 2007 Database gets converted to Access 2002-2003 format.

I am using a Delphi procedure to Compact Access Database Code sniphet of procedure is: procedure CompactDatabase(pFullDatabasePathName : string; pLoginName : string = ''; pPassword : string = ''; pSystemDb : string = ''); var JE : TJetEngine; sdbTemp : String; sdbTempConn : String; sdbSrcConn : Stri...

How to execute PostgreSQL funcion from VBA code?

How to execute funcion named Test1 that is stored in PostgreSQL from VBA code? For example. We have function definition as follow: CREATE OR REPLACE FUNCTION "public"."Test1" ( ) RETURNS bit AS $body$ BEGIN INSERT INTO test ("name") VALUES ('1'); RETURN 1; END; $body$ LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOK...

MS Access DB on network with multiple users.

Hello All, I have an MS Access database on a network drive with a userform which has multiple users (All using at the same time) The form runs an update-query which will add data into a raw data table. Does anybody know how I can make this work if two(or more) users run the update query at the same time? I assume this has to be done ...

Search filesystem for filepath using VBA

I am looking for a way to search a specific folder for a subfolder containing a certain string. Below I have listed a function I typed off the top of my head to see if it would work. Well, it does work but when I am talking about searching through 6,000 folders on a network drive it just isn't fast enough. I'm sure that there is a bette...

MS Access back end located on slow network drive

I currently have an Access 2003 app that is used primarialy by three people. It is split into a front end which each person has a copy of on their own machine and a back end on the server. When a user logs into the front end, the front end runs a start up routine that checks table links, version number and a few other things. The problem...

Change MS Office Button Icon

Has anyone found a way to change the icon displayed in the Office Button in A2007? Having converted an MS Access 2003 app to 2007, it's very annoying that my app is now displayed as an MS Office app instead! ...

MS Access 2007 Load Image to Ribbon

I'm trying to get to grips with customising a Ribbon Bar for a converted A2003 app. I'm trying to work out how to use my own custom images on button controls in the ribbon. Can anyone point me to an example for Access 2007 that can do this pls? ...

ODBC Drivers error '8007000E'. Not enough space on temporary disk.

Hello, I have a website in ASP + MS Access, and sometimes I get this error for several hours, then it starts working, and later I get the same error again. Microsoft OLE DB Provider for ODBC Drivers error '8007000E' [Microsoft][ODBC Microsoft Access Driver] Not enough space on temporary disk. I have seen that everytime I get this err...

insert xls/csv file into access 2007 table using vba

I have several excel files carrying 90 columns and about 500 rows, each file has a header of 4 rows, and I need to insert them into one access table. I am able to do the import by using the for...loop to loop all the excel files and all of the rows inside the file, but this is too slow. I have used mysql in R and it can be done easily ...

MS Access 2010: How to startup with a blank main window.

I want to write some VBA script so that when I start my access application the main window is blank. This is the list of things I need to be removed or hidden: The entire ribbon The status bar The navigation pane The window tabs In addition, I want to disable the popup menu when right clicking. I also want to disable SHIFT bypass key...

Tricky MS Access SQL query to remove surplus duplicate records

I have an Access table of the form (I'm simplifying it a bit) ID AutoNumber Primary Key SchemeName Text (50) SchemeNumber Text (15) This contains some data eg... ID SchemeName SchemeNumber -------------------------------------------------------------------- 714 Malcolm ...

MS Access sum of related records

I have a purchase form that has a continuous subform which shows line items for that purchase. Each line item needs to include a text box that shows the sum for a number of related records in a table for that line item. (Each line item is allocated for a specific purpose(s). For instance, a line item says that 100 widgets are ordered;...

MS Access 2010: Cannot find RunCode action

I cannot for the life of me find RunCode macro action in MS Access 2010. It should be in the drop down, or in the tree to the right of the macro editor. Where is it? ...

nested if statement in query

(please excuse that I didn't use aliases). I would like my query output to say "none" if 3rd qrtr sales equals 4th quarter sales, but my output is just saying "up" when they equal each other. Please help me correct this code trend: IIf([qryQuarterlyCustomersales3rdQuarter_final] .[3rd qrtr sls]=[qryQuarterlyCustomersales4thQuarter_fi...

Access 2003 - Capitalize first letter using queries

SOLUTION update COUNTRY set CO= StrConv ([CO], 3) Hi: How I can capitalize the first letter and all other letters in lower case? I need to do this using queries from own Access. Example, if I have stored countries: SPAIN, FRANCE, ITALY, ....I want to change them to: Spain, Italy, France,.... hanks in advance ...