Hi all,
I have a form "xx" based on table "Tblxx", with a combobox "CmbaaID" and I have a query "yy" based on table "tblyy". "Tblxx" and "Tblyy" are related with "aaID". The query "yy" is fil...
I am building a query that prompts for parameters, and I know how to have a box pop up so the user can enter in parameter(s). To control the input, I would like to have the user select a para...
I have a database where I store an ID as a text field. This ID can be anywhere from 1 to 5 characters. I am looking for an input mask that will always make my field 5 characters, the ID plus a...
I've found a few questions where this has been discussed but the solutions are a little more intense than what I'm looking for. I've got a form in an Access 2003 .mdb that I want to password p...
I have a form (Form1) with a button, ID field and a checkbox field(me.mrb).
I coded the button so if the check box is equal to 0 it will open a different form (Form1) showing all the recor...
Hi,
I am faced with a scenario in finding an employee's salary increase, both in dollars and as a percentage of the previous salary. Calculate how long the employee had towait for that increa...
Hi
Im attempting to create a query where the source data is from a linked spreadsheet. I need to append this to a database table but obviously do not want to include records already in the ...
the following code does not work
i have a table named ProjectTable with a field named Project Name and at least 1 record in that field that stats with the letter T
any reason why this code...
Hi,
I've encountered a problem at one of our clients that involves putting users and passwords into an access database using the user and permissions wizard. Our client wants a total of about...
I have an existing table for service ticket history that shows problem and resolution descriptions in seperate records linked by the ticket number. I need to combine the descriptions, keyed on...
I need to export 3 queries and save as 1 text file. I need this for our bank, AP Positive Pay.
The queries are:
qryHeader (One Line - First Line)
qryDetails (Beginning at the second li...
I have a database on my local computer that I'm running. One of the main outputs is a consolidated table which joins 10+ tables together to form one massive table with 1M lines. I have been qu...
Ok I am stuck. I have a mysql database that I am linking to in ms access via odbc. I have a date time field that shows as an epoch date. An example is 1203980271000. I have tried a number...
I have some code to update my linked tables if the database they are contained in has a new location. When I run it I get an invalid argument error on the .refreshlink method.
I have an excel macro that is pulling data from an access database via a sql string in the macro and dumping it into an excel worksheet. The data is from a date field and a time field that are...
I need to set the BeginningGrossAR to whatever the EndingGrossAR was for the previous record. I have written a function, but it's not working. I just get #Error.
Public Function Beginning...
Hi Experts,
I have 1 query that extracts e-mail addresses from clients that have made a booking, in order to e-mail them for their feedback:
SELECT First(Clients.Lead_Name) AS FirstOfLead_...
I have an Access2003 database that contains a link to an Oracle table that just recently reached 2Gigs in number of rows.
If I double-click on the link table, the first few rows come up no ...
Intermittent "Disk or network error" in MS Access application
We are having problem with MS acces Applications. MS access can't open the DB files over WAN. They work fine over LAN. When you t...
Hi Experts,
I have a string variable x = "Lavender's Road"
When I tried the following SQL expression in VBA:
strGetSQL = "UPDATE myTable SET myStreetName = '" & x & "' WHERE caseID IS...
I'm looking for a convienent way to plot several hundred addresses on a map. I've looked at Google maps and Yahoo maps but I wanted to get some additional ideas about which option would be be...
My db has about 50 tables linked via ODBC into the db.
Forms are populated via SQL-Selects in the datasource property.
This works all fine until today where one Subform pops a message the an...
I am trying to discern what the formula is to convert a hex # to a DateTime.
In a file I am trying to parse, the Hex Value is 992947609 and I know that it is equivalent to 05/07/2007 07:01 ...
My data base works fine...except when I put in a date criteria. I am using >Now() to return all events in the future, and it doesn't return any data..yet when I clear the criteria, it returns...
I would like to create a field in query in access which finds the total days of the patient being treated in hospital. for example the patient was admitted to the ward on 26/05/08 if the patie...
