Experts,
One of our clients has a number of Windows 2000 machines which cannot run our access ade.
The ade connects to sql server in code using 'Currentproject.OpenConnection'.
The ...
I'm using Microsoft Access 2003. I have a form with a button. When I click the button I want to find a particular record and then delete it. I started with an ADODB Recordset open function ...
I have a word merge system that is using an Access 2003 database as it's merge source. One of the fields I am printing is a date/time field. The date appears in the Access db as 8/14/2007. ...
I have two forms, Form1 and Form2. Form1 generates, by autonumber, a ContactNo from an underlying table into a field with the same name. A query (qryCurrentContact) is run on the Form1 tab...
I have an Access application that calls Word to carry out a mailmerge, printing the resulting document to a .pdf file, which is then emailed via Outlook to the customer. All programs are Offi...
Good Day All, I have a sub-subform that allows the user to summarize phone calls to customers. The main form is the customer's name, and the subform is an estimate tracker for the customer and...
I have a postcode table in my database (on SQL) and on my access form I have a Dlookup to look up the post code and fill in the address details.
I need to add the sql connection sting in the ...
Hello!
I have been working on a timer issue and had some great help in setting it up correctly. I had a suggestion from one of the experts to put a reset function if the user clicks someth...
Hi,
I have a problem to figure out this one.
When I open a linked word document that exist on a server share I got the following message in Words "task manager": Waiting for Microsoft a...
Sum two fields and put value into a third field. I am trying to add the value of both fields but I getting a figure not even close to what I have. If one field has 8 and the other has 16.4 I g...
I am writing a module to import an Excel 2000 spreadsheet into my access database. When I run the module(mdb file) by itself, the code runs and imports fine. When I call the form from anothe...
In SQL, how can I append data to a field. I want to be able to allow user to add ongoing comments to a comment field? Any thoughts?
If a line like
DoCmd.OutputTo acOutputQuery, "qryUserConflicts", acFormatXLS
is used to create an Excel spreadsheet from an Access query, any memo fields in the query longer than about 2...
I have a continuous form that contains records that either need to be assigned to person (through a combo box) or skipped (by checking a checkbox). I want to make sure each record is addressed...
OK, I am stumped by an easy one so I will toss it to you guys:
I have this code:
Function RunQuery(stQueryName As String)
With DoCmd
.Echo False, "Running Query " & stQueryName...
Hi, I am using the following to calculate number of records that have two date fields using the same date. However one of the date fields stores BOTH date and time - the other only Date. Bot...
So far in my experience with MS Access I have only used unbound controls and now I am trying to make use of a subform in datasheet view, which is bound to columns in a table, and I am confused...
I'm kind of stuck using MS Access 97 but I like it. I would probably have the same issue with a newer version. I've written hundreds of apps with access but never bothered to check a PCs resou...
Is it possible to word wrap text in a cell in datasheet view as you type so that the text will automatically wrap and the cell height will automatically expand? I tried the Can Grow? option bu...
My client may encounter the currrent scenario in the not too distant future
A database is used which aggregates monthly data from a reporting process into a table. The database is about 1....
I have a calculated field in a query, like
Viable: [tbl_U2_Spinners].[Viable]/[tbl_U2_Spinners].[total]*100
The returned value only needs to contain two decimal places. but looks lik...
Hi,
I'd like to write some code that could automatically parse various HTML pages and insert the table data into an access database.
The webpages are used for tracking courier data.
You...
I have a subform in datasheet view.
I want to remove the "row selectors " i dont know what they are called so I am calling them the row selectors.. becuase i dont want my users to highlight...
Hi,
I'd like to extract all the links, e.i : <a href='/XXXXXXXXX'>More Information...</a>, in the html page and import them into a table so I can later get into each link and pull out more ...
Hi:
I've been working the Excel Experts this morning on one "hyphen matter" so now it's your turn!
I have a table in which a field called [REC] has 7 characters. Some of these [REC] codes...
