http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21173221.html
I found someone who had the same problem as me (see above link). However, the solution was to allow zero leng...
Can Access 2003 and Access 2007 both run successfully on the same computer?
I get the above error when I try to execute the third line of this snippet:
Dim i as integer, tdf As DAO.TableDef
Set tdf = CurrentDb.TableDefs("MyTable")
i = tdf....
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...
I use the Dir function to retrieve a file list for a certain folder containing files that match a criteria.
Previously I was just using Dir(path & "*.xls", vbNormal) to retrieve excel files...
Hi all,
How can I force that every input to an field on a table comes with zeros on left.
Example:
User inputs: 1
Table saves: 001
User inputs: 22
Table saves: 022
I was wonderi...
I have two tables in SQL and need to create code to update the second table from data in the first table.
In table1 I have three fields:
IDnumber
StartTicket
StopTicket
In table2 I ha...
I have 6 excel files, that are in the same format, that I have to import into Access each month. Can I write a macro to import all of the files into Access as individual tables or even as a m...
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...
Hi,
I have an append query that is working fine, but i can not see on one field the decimal places
On my target DB the format field is:
Type: Number
Format: Standar
DecimalPlaces: 2
...
Hi
Ok I haven't used Access for years but I'm back in it now and simply trying to get the record count for a table in an external database...it doesn't work, here is my simple code......
...
I need to make a field in a selct query 30 characters long with leading zeros, the entries in the field are not a standard length so the number of zeros required is not consistant.
Thank ...
There are about 7 different departments (sales/marketting/qa/payroll/etc..) each of which record information on employees - storing the data in spreadsheets. The spreadsheets can contain mult...
hi . i have the following sql in my query
SELECT TbMain.CountryID, TbMain.StateID, TbMain.KindID
, Avg(IIf([TBMain.Time]=Forms!FSalesStock!ReportDateStart,Price/Area)) AS [M2 Start]
, Avg(I...
Hi All,
I want to be able to read a csv file using VBA inside the Access mdb that is attached and insert new data into the Company table from the csv file. The VBA should also be smart enou...
I need a script that will loop through an Access mdb and for each linked table: copy contents & definition, drop the linked table, and rename the new local to the original. I am somewhat famil...
I made a simple Access table.
I then made a form based on the table, to fill it in.
I put an expression in the form to calculate one field, based on the previous field (I enter a date, and i...
SO
i have created a way for when 2 things on the drop down box are selected the form then puts a value in a textbox. A lot of the text boxes are 0 because of the criteria i have laid down. i...
hi
i have the follwoing sql in a query
SELECT CountryID, StateID, KindID
, NZ(Round(STR([M2S]),0),"No data") AS [M2 Start]
, NZ(Round(STR([M2E]),0),"No data") AS [M2 End]
, NZ(Round(STR(...
I have a simple parent child table as follows:
Parent Child
Bob Bill
Bill Mark
Mark Jane
Bill Tim
Tim Joe
I am looking at how to populate the treeview co...
I know this has been asked many times before. I have read several Q's and their accepted solutions - but I have failed to grasp how to do this.
I have a Job table and an associated JobDiv ...
This is a follow up question to a solution that was provided to me from Harfang (copied below for reference).
I have two field listed on the main form F0. These field names are Cust and Cu...
We have a programmer that needs that option checked but it is greyed (ghosted, disabled) and cannot be changed.
If we go to Excel or Word that option can be enabled or disabled by a click. U...
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 an Access database that will send an email when the user clicks a command button. The functionality worked fine on one computer yesterday but is not working on another today.
The ...
