VBA in Microsoft Access
0
votes
1answer
22 views
Stopping NULL Rows and Columns to get imported from excel to access
I am importing some table from excel to access.Sometime some blank columns also are imported as field13 or field-x .
Whats the reason for that.
Also sometimes some blank rows are imported also.Is ...
0
votes
0answers
17 views
Access 2010 - Employee Database
Good afternoon everyone!
I am still quite new to Access and I am attempting to work on a database that is to be used for managers to be able to pull up reports on certain employees who are requesting ...
1
vote
2answers
50 views
Dividing a table in 2 seperate tables by parsing a string
I have a table that roughly looks like this:
the 1300 and 850 stand for frequency on wich these fibre cables are checked
The real problem is that the 1300 and 850 aren't set values. In a different ...
2
votes
2answers
28 views
How to combine 5 tables together with same ID in a query?
I have 5 different tables T_DONOR, T_RECIPIENT_1, T_RECIPIENT_2, T_RECIPIENT_3, and T_RECIPIENT_4. All 5 tables have the same CONTACT_ID.
This is the T_DONOR table:
T_RECIPIENT_1:
...
0
votes
1answer
13 views
Need to fetch returned value from sql procedure in access recordset
I am new in access and I am stuck in recordsets. I am running a procedure from access using correct connection string. the procedure is running perfectly fine.
Set con = New ADODB.connection
Set rs ...
0
votes
0answers
9 views
How to display field values as hyperlink based on a condition in access forms?
I have an access form in which a particular values of a particular field needs to be displayed as hyperlink if it is greater than 0. If the value is lesser than or equal to zero it should not be ...
1
vote
1answer
9 views
Displaying a record in a report when selecting the record ID in a combo box
I have almost finished a project and I would like some user options in the form.
I would like to allow the user to select a product code and when selected, it will find the relative record in the ...
1
vote
2answers
35 views
Copy Row to same Table in new Database
I have very little experience with Access Databases however I have wrote a similar VBA macro in excel. I am trying to copy rows from one .mdb file into the exact same table on a different .mdb file. ...
0
votes
2answers
29 views
Access 2010 VBA manually save record
an Access question this time. I have a form that is bound to a certain table and I want this form to only allow adding new entries (not editing or deleting) by clicking on a "Save" button. First ...
1
vote
2answers
25 views
MS Access report opens Navigation pane when printing multiple copies via VBA
I have report I am using to print labels with and everything works fine except that when the report prints, the Navigation pane opens. I have set the database options to not show the navigation pane ...
-1
votes
0answers
14 views
Access VBA How to export specific query fields into separate columns of a worksheet
New (access/excel 2007) VBA user trying to get to get grips with it.
I have a query in Access that generates several fields. I want to export certain fields into specific (non consecutive) columns of ...
1
vote
1answer
19 views
Extracting data and Comparing Microsoft Access
I have two tables in Access 2003, these tables hold model numbers and account numbers, with the serial number being the primary key. How could I go about comparing a the same serial number in the two ...
0
votes
1answer
20 views
open particular slide of powerpoint presentation from access vba
I am currently using the following code in Access VBA to open a presentation when the path is stored in a variable "link".
Dim pptPres As PowerPoint.Presentation
Dim pptApp As PowerPoint.Application
...
-1
votes
1answer
15 views
Import Excel sheet to access table with different column names but same data type.
Folks,
I am learning access, but have sufficient experince with .net. The below utility has to be developed in access.
I want to upload/import data from an excel sheet to an access table which does ...
1
vote
2answers
49 views
Running VBA macro within Access 2010 from external VBScript
Not sure this is possible, but it seems like it should be doable.... it is 2013 after all! And some forum posts I found suggest it is, but I have not been successful in getting it to work...
I have ...
