Tagged Questions
0
votes
0answers
9 views
How to extract XML data from ISBNDB.com API using VBA?
I have never worked with XML before and while I keep trying to piece together things on the net, I am getting nowhere (and in more ways than one!)
I am trying to set up a vba module that will run ...
0
votes
1answer
27 views
How to run query based on information from InputBox?
On my form I have a button which the user can click. It will then prompt the user with 3 input boxes, where the user can enter in the information that he wants to run a query on. I want the query to ...
1
vote
0answers
16 views
Trying to copy an Excel sheet to another workbook from within Access
I'm trying to copy an excel worksheet to another workbook from within Access and keep getting the subscript out of range error. I've tried a few different things but can't seem to nail it. Any help ...
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 ...
2
votes
1answer
33 views
SQL Server Passthrough query stored into an Access VBA recordset
We've recently created and migrated our Access DB backend to SQL Server. I'm trying to, using VBA code, create a connection to the SQL Server backend and run a passthrough query with the results ...
0
votes
3answers
48 views
How can I tell whether the saved values are encrypted or decrypted?
I have managed to build something into a bound MS Access form that encrypts names as per client's request. This process also decrypts the data. I need a catch all that looks at what is in the input ...
0
votes
2answers
20 views
access 2010 getting max row in excel 2010
I have a problem in accessing excel 2010 via MS access 2010.
From access 2010, I want to get max row from my excel data.
Here is my code:
Dim Xl As Excel.Application
Dim XlBook As Excel.Workbook
Dim ...
0
votes
2answers
30 views
How to bind VBA code to a click?
I've made a graphical navigation system so the user can easily find the record he/she wants to. I'm using this on multiple forms now, and since I'm going to use it on another form, I want to ...
1
vote
2answers
33 views
How to run query based on information from specific customer?
I have a form that is tabular and displays all of the information from my main table. I want to be able to double click on a record (if possible a record selector), then run a query based on the ...
0
votes
1answer
16 views
Average Time between Two Date Fields in MySQL?
I'm working on a MySQL database that tracks call center phone contacts. Phone agents put in call information with an Access application, and I'm generating a report based off that information, either ...
0
votes
1answer
43 views
VBA Access: XML, Error '91': Object variable or With block variable not set?
Now that school is out for the summer and I have some free time I have chosen to create a personal book inventory system. While researching I came across this post by Jules: ISBN -> bookdata Lookup ...
1
vote
0answers
29 views
Type mismatch with VBA while other computer works well
On access in VBA, I use the Graph.Chart object to rezise all the text so it fits well and change the titles to match the data displayed.
I tested severals computer and everything works well, but in ...
1
vote
1answer
29 views
Getting the value from the first row where column name is <value>
I have a form where a user inserts some values
When the user clicks the "ok" button Access makes a new table to save the values from disappearing when the form closes.
strSQL = "CREATE TABLE ...
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, ...
1
vote
0answers
16 views
Creative way to monitor an OCDB Access VBA app as a Service
I've got an Access VBA application that is responsible for querying a SQL table once per second over ODBC, looking for records where processed = 0. When it finds one, it will process an Access report ...
