Tagged Questions
1
vote
1answer
24 views
Error with my SQL in vba
Dim rs As DAO.Recordset
sSQL = "SELECT Stock, Scanned FROM Products&
WHERE ((([Stock])=Forms!Products![StockCode]))
And ...
0
votes
1answer
15 views
Checking if a record exists using two fields
I have two fields that are going to be scanned into my form, I have a button on the form and when its pressed I want a Dialog box saying weather the record exists. I currently have an SQL query that ...
0
votes
2answers
30 views
Microsoft Access SQL Injection
I need to fix some security issues in a non-IT app that we were assigned to maintain. It's in Microsoft Access front-end (SQL Server back-end).
Does anyone know if SQL Injection can be done via the ...
1
vote
1answer
36 views
Data Type Mismatched Query
i'm using VB and Access, tried to use Select Statement filtering WHERE EmployeeID equals to userInput which is an int value, but giving me an error Data type Mismatched
Set MyRec = ...
0
votes
0answers
71 views
Checking if a access table exists in Excel vba( dlookup or using sql)?
how to check if table exist and if it doesnt exist create table in sql server 2008
The link above I think shows what I am trying to do using sql in excel vba. I should say I don't really know sql, ...
0
votes
1answer
40 views
Returning values of fields on active subform
I'm trying to pass data from a form with a subform into a microsoft word document, form and subform in this image:
I have code for passing the form data, but I'm not sure how I reference or request ...
1
vote
1answer
67 views
Importing data from access into an open excel spreadsheet? (Excel VBA)
I am trying to make an application that has the feature to import data from access into excel. I am starting with a table named ""1301 Array"" before I give user control over which table. The problem ...
0
votes
2answers
36 views
Creating an SQL query in MS Access for a dropdown box lookup in a subform?
I have the following two tables, the first called Projects and the second called Parts:
I then have a form (lets call it Form 1) that uses Projects as its Record Source with a subform that links ...
1
vote
1answer
16 views
Errors with linked tables and Ms Access ( Run-time error '3622' : dbSeeChanges/Identity column )
I am trying to output the name of all linked tables, including their fields which are Date/Time, and that fields values.
The following code can output the first table, field name and their first ...
2
votes
1answer
24 views
Flag Records From A Filtered Form
I have my Form set to filter to make sure that only clients who need to be mailed are loaded into this form.
[Complete]=No And [Call 1]="Wrong Number" Or [Complete]=No And [Call 2]="Wrong Number" ...
2
votes
1answer
39 views
Access 2007: Update Table base on Another Table
This involves 2 tables in our Access 2007.
A "Station Master" table consist of records of workstations
A "Move-Add-Change" table consist of records for move, add, change steps for specifics Project ...
0
votes
2answers
43 views
Checking form fields against table fields access 2007
Private Sub Command34_Click()
If Name.Text = [Table1.Name] and Address.Text = [Table1.Address] Then
MsgBox "Match"
Else
MsgBox "No Match"
End Sub
I am trying to have my ...
2
votes
1answer
23 views
copying a form textfield value into a report textfield
I have an access form in wich a user can enter project details (like project number, name and ordering party etc etc)
I also have a few reports with a header. I would like the values that are ...
0
votes
3answers
33 views
Changing TextBox fields on Lost Focus
I am making a database with access 2007. I have a form for the call center to enter customer info; Name, Address, Phone Number, ect.
There is a field for credit card numbers and while we are supposed ...
0
votes
1answer
28 views
Trouble outputting a recordset value with fieldname a reserved word in VBA
In vba, I've created a recordset called 'rs' that includes a field named "EmployeeName" and another named "Position". If I execute
ThisWorkbook.Worksheets("Contact").Cells(row, 1) = ...
