I'm writing code to mask out Access's normal keys/key combinations that change the selected record, add a record, or delete a record. Here is what I have come up with so far:
Tab
Arrow Key...
Hi,
I have a Temp table which collects imported data from another system. What i need to do is then import specific columns from this table to another table.
The temp table has columns ...
Hi,
I have the following code an a cmdButton which opens a report to print:
Private Sub cmdPrint_Click()
If OpPrint.Value = 1 Then
DoCmd.OpenReport "rpt_scannedfiles", acViewPreview, M...
I'm preparing some code to automatically import several sheets from an XLS into Access. I want to first check the sheet to see if it has anyting to import. I know that if I can cell A2 for n...
Hi
I'm developing a database for a music shop for a college project. I have a form setup whereby Customer record is the main form and Order information is the subform. On the customer form...
Can someone please show me how to set the field as a variable in the following code so that I can easily use it on multiple fields on my form? Thanks.
Private Sub HoldForFinals_AfterUpdate...
I am having an issue with the Open Method (ADO Recordset).
The line:
rsStudents.Open stQuery, con, adOpenDynamic, adLockBatchOptimistic
In the snippet below returns an error of "...
Is there a way to only display the forms and not the application like there was/is in Excel VBA?
I'm getting the error "Data type mismatch in criteria expression". My code is almost completely from the book and I'm feeling very incompetent. If anyone can debug my code, I'd really apprec...
Hi,
I'm trying to show the number of records return from a filter in a text box. Currentl it works fo the complete record source (ie, it shows 1 of 101 records etc.) What i'm trying to do...
I have three combo boxes on a form to filter reports...
cboJobNum
cboPipeOD
cboPipeWall
I want all of the filters to be optional. How do I set up the where clause of the DoCmd.OpenRe...
I would like to make a function I am using more generic. Right now I have 2 versions: 1 version for listboxes and 1 version for comboboxes.
I would like to have just 1 single function inste...
I am trying to make a function I am using more modular.
My sub was hard coded to a specific control on the form, but now I have moved the function to a module, and I'm passing in the form and...
I have a script for a table call test in Access look in a field call LIN for null value and copy the last none null value until next none null. I need this to loop until there is no null in t...
Everytime I open this database it runs through all it's import steps, macros, queries and then compacts and closes automatically. I just want to open it and look at the design views, tables an...
Hi, I would like to perform calculations on a form (or in the database table if its best practice) which once made is stored in the DB - the calculation must be performed on values which are a...
Trying to build a criteria stmt in a update query. Need to update a field Algebra1 with a value in another field called Calst2math if the field Fld1 = 3
if Fld1 = 3 then Algebra1 = Cal2Math...
I have a form with a bunch of text fields that have control source. The form uses a "SELECT * FROM table_name" query. At the top of this form is a listbox. The listbox is used to filter the fo...
I have a listbox on a form that always starts out without any items selected. I would like to pre-select the first item of the listbox when the form loads. How would I do this?
I have written a macro in access (FTP.mdb) which goes to a ftp site, gets the dir info., generates the new list of file for downloading, and then does the actual downloading. I would like to ...
Hello Experts,
I have 2 tables relating to - table 1: customers - table 2: items. Each table has an autonumber as the pk. Each autonumber has the format property set to \C00000 for custome...
I am working on a project that has a unique combobox and listbox record selection setup.
I need to have a listbox select the first item on 2 circumstances:
-When the form first loads
-Whe...
Hi all,
DMin syntax always get me!! :(
Dim strPricingBase As String
strPricingBase = "Automatic"
PriceBox.Value = DMin("Price", "tblPrices_FabricAwnings", "Width>=Form![WindowWidth]a...
I've successfully written Access records to Outlook tasks, specifically for reminders.
But how can I tell if Outlook is available? For example, a corporate user might have Lotus Notes. In t...
I want find a comma in a string and grab all characters before and after it in 2 separate variables
str = "smith,Sam"
Variable 1 = "Smith"
variable 2 = "Sam"
I think i use a For I but...
