Hello,
I have a common problem in a database I work on, whereby there is a tab control on a form with datasheet view subforms on one or more of the tabs. When the form is stretched, the tab...
I am trying to run an append query in batch. This query has two date parameters. The query works if I run it directly. I am trying to execute it using the ADOX command method. When I try to as...
I have multiple check boxes each connected to a bit field.
When the ADP was connected to SQL Server 2000 they functions correcty.
Three weeks ago we upgraded to SQL Server 2005.
The check ...
I get the error message "Object variable or with block variable not set" from the following code. The debugger stops on the rsCNCProgRecord.Open line.
Function FindNextCNCNum() As Long
...
I am writing a query and I have 3 fields which are populated with a numeric value or a null
How do I return in another field what the highest value is?
I thought it would be something li...
I posted this earlier but have yet to resolve it. I currently have the visibility of the Co-Borrower fields hidden (Example 1) unless the CoBorrower check box is checked (Example 2).
This ...
Hello everyone!
I have a treeview control that is built up from records with a recordset. I can choose an item in my treeview control and it will allow me to open a form and goto that speci...
Using an example
Access 2003
create a table with 3 fields, add some random data
create a second table with one field
set the lookup parameters to
SELECT Table1.f3, Table1.f2, Table1.f...
Hello, this is my very first Access Database....(I feel somewhat overwhelmed).
In Table1 (design mode) I wrote "ordering facility" in the FIELD NAME column.
Under the DATA TYPE column, I s...
Hi experts,
In ds form i have some calculated columns(either by functions, either they are clalculated as the sum of other fields) and i want to allow the user to sort ascendig or descendin...
Hi Everyone.. this is my first post!!
I have a Table for our prospects and am trying to create an update query that will update from 3 boxes on the form.
I'd like a dropdown box to selec...
Hi,
I'm trying to use a TempVar in a query criteria [Application].[TempVars]![tvSupplierNo] where the TempVar is set from code.
Is thier a way to display all records when no criteria is re...
I have more than 180,000 rows of data stored in a csv file and/or Access database. Each row has 10 data points that I want to plot in a line chart. Right now I copy and paste from EditPlus t...
I have two tables with the following fields (all of them are primary keys):
tblOrderDetail: OrderID, ProductID
tblMaintain: OrderID, ProductID, MaintainID
I would like to delete tho...
Below is what I have in the query field. I thought it would return a value if it does not find one of the asked for values in the SalesType or SubType. But where their is no print cost avail...
Hi,
I have a function to import a file. the file is importedperfectly, but when my function ends I get the error;
Run time error '424', Object Required. My code is
ImportFile(txtArtemis.V...
How can I position a form (progress bars) at the bottom left of the screen regardless of other factors such as resolution. I have seen this done for visual basic and delphi but I haven't bee a...
I have a small query which I want to use as the basis for a Crosstab. What I am hoping to build is a simple view of a production schedule which displays the Line Number, with the Date and the...
I have two fields - date and time in Access. They work fine.
However, ArcMap doesn't support a time field, so now I need to combine the date and time into one (new) field. The new field m...
I have the following code to open pdf files:
Shell ("C:\Acrobat3\Reader\AcroRd32.exe " & strFileName), vbMaximizedFocus
How do I change it to open Doc files in any XP environment?
Tha...
one of our users is unable to open some Acess db's through explorer or their desktop shortcuts. This only happens on some db's that they open some open fine and they can open everything if the...
Hello,
I need help (a lot of it) writting a query (for MS Access) to produce the below report. There are actually more columns than this needed in the report, but if I can get this many, I ...
In my Access 2000 app there is a process that must import a file from an outside agency every month. Since this is a repertitios process I created a menu option that would handle all of the i...
I have some code which generates an HTML-formatted Outlook message. My problem is that the line spacing appears to be double-spaced but I want the text to be single-spaced. Here is a sample ...
I created an Access 2007 database that is deployed. It works fine, however, I've just discovered that Shift+F2 does not "zoom" for all users. I've tested and know it's not the field, but the...
