Questions regarding the Microsoft Access 2013 database management system.
0
votes
0answers
3 views
Allowing users to select files in a dialog box in runtime 2007 from Program designed in 2013 VBA
I am building a program in Access 2013 and I need to be able to allow the user to select a file and then import that file into the database. The user is running the Runtime access 2007 program. So ...
-1
votes
1answer
20 views
Determine if Attachment field is empty
How can you determine if in Attachment field in Access does not contain an attachment using VBA? I tried
If IsNull(rstMassBalance.Fields("FileName"))
and
If rstMassBalance.Fields("FileName") = ...
0
votes
1answer
14 views
How Can I Perform Date Comparisons in Access 2013 Query Criteria?
I have a date field in my table, and I'm writing a query in Access 2013 to select all items where the date is between 7-days-ago and 30-days-in-the-future.
Currently, I've added the following as ...
1
vote
1answer
44 views
Please help on 'Operation must use an updateable query'
Have been going through all the earlier post on this error dialog "Operation must use an updateable query". Unfortunately i have not been able to fix the below query.
Inventory: Is a table.
...
0
votes
0answers
20 views
Migrating Existing Access Database to Sharepoint
I have an existing Access database. This has grown in importance within the company and now others need access for data entry and running existing reports and queries.
I have a site on Office 365: ...
0
votes
1answer
30 views
How do I use a subquery in an Access Web App where clause?
I'm working on creating my first "Web App" using Microsoft Access 2013 and publishing it to my company's sharepoint portal. So far it's working excellently, but I can't seem to wrap my brain around ...
-1
votes
1answer
35 views
Update query using Max in MS ACCESS
I'm new to MS access, I have a question.
I have 2 tables let say A and B.
I would like an sql query which updates the table Table A from Table B, based on ID and Max(Order Rank)..the result ...
0
votes
0answers
58 views
After installing Office 2013 my VB6 app crashes opening an Access table
Thanks for reading. A customer has installed Office 2013 and as a consequence my VB6 app crashes when trying to read from my apps database. The database was previously a 2010 Access DB. The following ...
0
votes
1answer
36 views
Referring to the filename of an attached file in Access 2013 with VBA
If I have Files in Attachments fields, how can I get a filename as a string using VBA? They're excel files so I want to do something like this:
xlApp.Workbooks.Open("M:\strFilename.xlsx")
0
votes
1answer
13 views
Ordering records by foreign field while maintaining adding capability
I have an Access form that lists all records in a table. One column in that table refers to a 'device' table, which then has a foreign key reference to a 'brand' column. In the form, the brand name + ...
0
votes
1answer
43 views
“Validation Rule” in MS Access for a string column for having only numeric digits
Is it possible to have a "Validation Rule" in MS Access for a column of text/string data type that allows only numeric digits? And a "Validation Rule" that allows only alphabets?
0
votes
2answers
19 views
prevent last record in access table to be deleted
I made a loginform for my access database but how to prevent anyuser to delete the last record
Ex: if there is two records in login_table or more. The user can delete all the record but not the ...
2
votes
1answer
24 views
Find missing values, constrained by another value
I have two tables. Table1 contains unique account numbers, and unique account names. Table2 contains related account numbers to Table1's account numbers, but also another "parent" account number.
...
0
votes
1answer
68 views
how to use VB code to insert into an Microsoft Access database
I am very new to Microsoft Access. I need to write VB code to do a database insert on a button event click. The insert should take info from the form that the button is on.
I know that you can get ...
0
votes
2answers
24 views
Issue using VB in access to open up form with OpenForm
I have a Inventory form. I want to create an Update button which, when clicked, will open up a new form frm_add-remove, which will contain only the selected inventory item and will allow you to edit ...
