current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0

Tagged Questions

0
votes
1answer
14 views

MS Access 2010: Keep open object after 'End Sub'

I have a code that opens an external programme's application window as a VBA object. The code opens a GUI in that external programme that the user then interacts with. I currently have an issue where ...
-1
votes
1answer
43 views

ORDER COLUMNS TABLE VBA

I would like to reorder all the columns from several tables (Set as Table in Excel) one below the other adressed in the same Worksheet. This is an example so you can have a better understanding of ...
0
votes
1answer
12 views

DLookup in ControlSource property of a TextBox

I'm working on a little project in Access using VBA. I created a report with some data from three different tables. In the Report_Open method I want to assign a query to the ControlSource of a ...
0
votes
1answer
33 views

Clear text box on form after a few seconds

I would like to find the best way to have a text box displays a message everytime another control (a button) is pushed. Each time the button is pushed, the message will change and that message should ...
0
votes
1answer
23 views

Use vba to refresh & renew table links

I have designed a system that is used to track customer activity and log calls to a department. The front end and back end database are written in access. This system is due to go to the USA division ...
0
votes
0answers
12 views

Microsoft Access 2007 Database Application HTML Help opens multiple instances of chm file

We have created help file (.chm) using HTML Help Workshop, In Access 2007 database Form property, we have set "Help File" = HelpApp.chm and "Help Context ID" propertiey = 1001, so when we press F1 ...
-2
votes
0answers
32 views

need help in access database (VBA)

I created an access database, I have 2 tables (sales table and stock table) and from that I created 2 forms (sales form and stock form) In simple, when a sales is made from the sales form I need a ...
0
votes
1answer
24 views

How to handle the click function in Access form

I create a form in access 2010 like this: When I click to the OnClick event, it open this window: I don't know how to convert this marco to VBA. I already check to Allway use event proceduces ...
1
vote
1answer
20 views

access form won't update while combobox is being edited, must move to next record

I have a continuous form with a list of comboboxes, pic here: As you can see there is a small pencil on the left side of the access form to display that the current record in the form is being ...
0
votes
1answer
22 views

VBA Acess Function - Return Outlook Folder/Inbox as object

Private OutlookApp, Nms As Object Sub TestSub() Dim Fold As Object Set OutlookApp = GetObject(, "Outlook.Application") Set Nms = OutlookApp.GetNamespace("MAPI") Set Fold = outlookFolderpath("Test ...
0
votes
0answers
25 views

Differentiate Between Empty Control Property (String) And One Set to “” (ZLS)

How can VBA tell the difference between empty string property and one set to ""? Problem: I want to differentiate between a control whose defaultValue property (a string value) is empty (unset, blank ...
0
votes
0answers
20 views

Interacting with an IE form through MS Access

Gang, I'm in desperate need of some help. Here's the deal, I'm trying to interact with a webpage form through an Access database. I've got almost everything I need; however, I need to interact ...
0
votes
1answer
32 views

Difference between objRecordset.MoveNext and loop?

My code reads in lines of a .csv file (comma separated file) and assigns each value to a local variable. After I have done some logic and stored the values in a table, I read in the next line of the ...
-2
votes
2answers
31 views

Read file using ms access (vba)

I am working on ms access 2013 but found some error. I'm trying to read data from text file but it show error. I search everywhere but not replicate the problem. Please help me to resolve this ...
0
votes
0answers
26 views

Updated version of Lebans SetGetSrollBar Code

I am looking anyone who has managed to re-write the code written by Stephen Lebans to Get or Set Vba Access's Scroll Bar for Access 2013. The code does not seem to work in the latest versions of ...
0
votes
2answers
31 views

Check if entry is already done

I am looking for a smarter way to check if a text in a record already exists. Basically I wrote a database which stores minutes. Since only the latest information should be stored in a textbox (there ...
1
vote
2answers
34 views

Inserting into SQL Server using MS Access

I know this will be a common problem, nevertheless I didn't find any solution. I migrated my access database into SQL Server Express. SELECT and UPDATE work well, actually better that with the Access ...
0
votes
1answer
26 views

Can't add attachment to email using VBA

I am having a very strange problem with this code. The general purpose is to save user data from a form in Access to a spreadsheet in Excel, and then use an email client to send an email containing ...
0
votes
1answer
20 views

FindFirst in opening Form

I have an overview form (list with all numbers and titles) which has a search field which opens another form with detailed information to an issue. Each issue has a special number so it can be ...
1
vote
1answer
33 views

Only user -defined type defined in pubic object modules can be coerced when trying to call an external VBA function

I am trying to call an Access function from Excel and get this error: "Compile Error: Only user-defined types defined in public object modules can be coerced to or from a variant or passed to ...
-1
votes
3answers
42 views

How to insert values into the database table using VBA in MS access

I've started to use access recently.I am trying to insert a few rows into the database however I am stuck as it is throwing an error which says Too parameters I have a table test with only one column ...
1
vote
1answer
63 views

Creating a Document Database using Microsoft Access

I am attempting to create a table within a database which store all of the documents related to the database "in it". What I really want to do is have a file uploaded and have vba code which copies ...
1
vote
1answer
32 views

Is it possible to search for, then to read in specific values from an Excel file using Access VBA?

I have had to read in values from an excel file before, but it was a Excel comma separated file. This time I have an excel file with a graph and two tables. I only want to read in the values in one ...
0
votes
1answer
37 views

Forcing a clean close of forms before access quit

I have an Access 2010 database which is using a form frmTimeKeeper to keep track of the users in the database. The form itsself has a width of 0 so it cannot be seen. It is the first form opened when ...
0
votes
1answer
16 views

No value given for One or more required parameters in visual basic 6.0 with access 2007

I am trying to do a simple select in a access 2007 DB as: sqlSelect = "select * from Datos_De_Quejas where Ape_Pax = " & textape.Text & " " RS.Open sqlSelect, cnn, adOpenStatic, ...
1
vote
1answer
29 views

Combo box in form (Access 2010) - Retrieving values from 2 different fields

I need to create a Form on access 2010 that navigates among records from a table (t_main) but the problem is that I need a combo to select among param1_old and new and also among param2_old and new. ...
0
votes
0answers
23 views

How to reduce the file size of an image in access using vba

I have an access file and i want to find a way to reduce the file size of the images that i insert using VBA code. More specifically they gave me an access application where you can insert an image ...
1
vote
0answers
38 views

Chicken or Egg… Define Engine before Export to MySQL from Access, how?

In a bit of a quandary here, having been trying many ideas I think I'm stuck with a several hour export. I have a handful of queries that export out to MySQL from Microsoft Access every 24 hours, ...
0
votes
1answer
61 views

MS Access Form where user name is selected from list

I am going to rephrase a previous question that I had posted: I have built a form in access that allows users to enter in their hours worked by activity (i.e. transactional processing, project time, ...
0
votes
1answer
35 views

Access Form Prompting a for User Name

I have built a form in access that allows users to enter in their hours worked by activity (i.e. transactional processing, project time, vacation etc.). Current the form has a field for user name, ...
2
votes
2answers
36 views

How to detect what control triggers BeforeUpdate event in Access 2007

I have an audit trail that uses the BeforeUpdate event to track changes made on a subform using the following code: `Dim USR As String Dim TS As Date Dim Connection As ADODB.Connection Dim RecordSet ...
0
votes
1answer
29 views

GoToRecord Runtime Error

wrote a code to check if a special issue already exist and if so goes there. The code is actually working fine but as soon as j = 1 there is an error after the correct record is showing. So basically ...
0
votes
1answer
32 views

VBA Access: How to zip and encrypt a directory from VBA Access?

Do how does one go about Zipping a directory and and encrypting the zip file using VBA Access using the windows standard zip function? So far i have managed to find code which Creates a Zip file and ...
0
votes
1answer
42 views

How to execute inline query as a pass through query?

I'm trying to delete records from table and it works when we have local table in MS Access but when I convert it into linked table (via SQL Server) then it will through some error. I have searched ...
0
votes
1answer
35 views

Most efficient way to column values to create a tables in access using VBA

I have a table with recipes. For each recipes ID I have 5 columns (ingredient1,ingredient2 etc) were I store the names of ingredients. Then in the same table I have 5 columns were I have the ...
0
votes
0answers
24 views

Change the SourceObject or RecordSource in Access 2007 VBA

I have a subform that is linked to a query. I need to be able to change the subform to display five different queries that all have different fields in them while also being able to lock certain ...
0
votes
0answers
27 views

Highlight specific row of Excel file through Access-VBA

Access 2010 ...I have code that reads in each line of an .csv file (saved as an excel document). My goal is everytime a certain criteria is met in a line,that line in the excel file will be ...
0
votes
1answer
38 views

VBA how to run a string as a line of code

Is there a way to convert a string into an executable line of code? something like: Dim Line1 as String Line1 = "MsgBox (""Hello"")" Execute Line1 resulting in the pop up box saying Hello. What ...
0
votes
1answer
19 views

Losing ability to change properties when changing SourceObject of subform in Access 2007

I have a subform that changes where it gets its data from based on user input by using the Me.SubForm.SourceObject = Query.SomeQuery. It seems that by doing this, I am losing the ability to set the ...
0
votes
2answers
35 views

How to get file extension using Microsoft XMLHTTP using VBA

I'm using the following simple code to download and save some files from the internet. The server that I'm connecting to sometimes generates excel files and the other times text files, I would like to ...
1
vote
2answers
43 views

INSERT INTO - Reference outer table in Values subquery

I am not that good at subqueries. I am trying to essentially create columns by selecting certain values from another table, and then insert those columns into my table [Presummary 7/24 . . . AM]. The ...
0
votes
1answer
22 views

Access-VBA: How do I detect the mouse-key in a TreeView-NodeClick

I have a TreeView with a Click-Event. Since I need to implement a node-oriented dropdown-context-menu by right-click, how may I check in the existing Click-Event if the right mouse-butten was pressed. ...
1
vote
1answer
39 views

Execute sp_password (stored procedure) from VBA when the user's SQL server password is expired

I have been researching this for a while and I still haven’t been able to solve the problem. I have developed a front end (in MS Access using VBA) that allows users to easily enter, view, and interact ...
0
votes
1answer
23 views

VBA query Inserting Time instead of Date

I need some help with my query I am trying to insert to a table see above code: CurrentDb.Execute ("INSERT INTO tblWarehouseItem ( whiwrhID, whiItemName, whivatName," whiVatRate, whiimtID, whiQty, ...
0
votes
1answer
25 views

How to get data from linked table?

I'm new in VBA so i don't know how to get data from linked table in ms access, But i tried some code but it show this error "Run time error '3219' Invalid Operation I already search this error ...
0
votes
2answers
41 views

How to set the Before Update property via VBA in Access 2007

I have a subform that changes its record source (Form.SourceObject) based on user input. I am developing a change tracking system that relies on the Before Update property of certain fields in the ...
0
votes
0answers
31 views

Dynamically adding/removing fields in a split form using VBA

I am attempting to create a split form in Access that will change records depending on a users selection. Each record is based off a query and each query has slightly different fields. I would like to ...
0
votes
3answers
33 views

How to implement user-level security in Access 2007

So after some digging I realize that there is no built in user level security option for Access 2007. What I need to do is restrict records that users can edit based on who is logged in (they can see ...
0
votes
0answers
26 views

Access 2010 - Query as record source for subform

I need to create a query containing all data fields from another table. This query will be used as a subform's record source. I had a lot of trouble with making this query dynamic, as in allowing it ...
0
votes
0answers
18 views

MS Access import Excel filename into field

I have created a macro in Access that will import an excel spreadsheet into the desired table using TransferSpreadsheet. The code can handle changes in the filename so that when the user creates ...

1 2 3 4 5 … 35