0
votes
0answers
19 views

Using VBA to change criteria on a query based on a table content (in Access)

I'm relatively new to VBA in Access and need help to automatize something. I have a query with my salespeople performance month by month. I use one criteria to filter the information by salesperson. ...
1
vote
1answer
49 views

Unable to edit data on datasheet in Ms Access 2013 - Get write conflict

I have been tasked with converting an old ADP project to something that Access 2013 can handle. I've imported all the forms and VBA, relinked the tables and changed the connection to an ODBC ...
0
votes
0answers
42 views

Edit record on grid in an MS Access subform will not allow saving changes?

I am troubleshooting a form that was created in an older version of Access. There is a datasheet view on a subform of the main form. This form shows data but it will not allow me to edit the data. ...
0
votes
1answer
50 views

Passing an element name using a variable in VBA

I have a multi page element on a MS Access form and I am trying to use GetArgs to identify which page to open using the below code. Dim WrdArray() As String If Not IsNull(Me.OpenArgs) Then ...
0
votes
0answers
64 views

MS Access Personal Macro Workbook

In MS Excel I have a personal macro workbook that is with me no matter what excel file I open. Is there a similar solution available for MS Access? The reason I am working on this is that i want to ...
0
votes
1answer
208 views

How to one-click print in Access 2010

I want to create a button on a form in Access 2010 that, when clicked, prints the current record/view of a form. I have tried various VBA scripts. Some print all records, others print partial parts of ...
0
votes
0answers
26 views

how to toggle values and look for a lable ms Access 2010

Function ToggleLabels(ByVal lblName As String, lblStyle As Integer) Dim objL As Label objL.Name = lblName If objL.BackStyle = 0 Then objL.Caption = "" objL.BackStyle = 1 ...
0
votes
0answers
10 views

Access VBA code combination not working, issue with exit sub? [duplicate]

I'm very new at VBA and I can't seem to solve this problem. It seems like it should be an easy problem to fix, I just don't know how. I've looked around on the web, but the question remains unsolved. ...
0
votes
2answers
635 views

Acces VBA code combination not working, issue with exit sub? [closed]

I'm very new at VBA and I can't seem to solve this problem. It seems like it should be an easy problem to fix, I just don't know how. So what the code does: In the main form is a record. This record ...
0
votes
2answers
493 views

VBA remove string by a specific character

I have a String str = "abc#daso.xlx". I want to remove all characters in front of "#" so str -> "#daso.xlx" . I can't use Left or Right function because the length of the string in front ...
0
votes
1answer
417 views

How to export multiple Access Class objects to text from Microsoft Visual Basic for Applications at a time

I have a lot of access files that have Code Behind event procedures defined using VBA. I want to search this code for a large number of strings. I can accomplish this by selecting the Access Class ...
0
votes
1answer
72 views

Windows Help Shows Blank Window

I use Access 2000, and when I am using the VBA IDE, I sometimes press F1 for help on a certain keyword. Afterwards, the help window shows, but it's a blank white window with a title bar stating ...
2
votes
1answer
273 views

Access 2003 VBA Form_Timer not firing during mouse drag

I want to catch a repeated 500ms Form_Timer event while dragging the mouse. i.e. between mouse down and mouse up events. The Timer event is firing outside of the drag but not inside. The reason for ...
2
votes
1answer
1k views

How to return current record number in Access?

I want to have my table to automatically returns current record number. What functions should I input in default value of this field (indicated in blue arrow) in order to automatically generates ...
-1
votes
2answers
347 views

IF value OR value Then [closed]

Using Access VBA we need to do an IF-Than statement but there are 16 values. So, I have tried including "OR" but this code returns error "Can't find the field 'I' referred to in the expression. Here ...
1
vote
2answers
5k views

How do I use Expression Builder in Access to create a LOOKUP function?

I recently moved from Excel 2007 to Access 2007 to manage what never should have been spreadsheets. Unfortunately, from what I can tell, the LOOKUP function in Excel does not exactly work the same as ...
0
votes
2answers
2k views

How do I publish/export Microsoft Access Forms

I developed some forms in Microsoft Access and have yet to connect the forms with the database. However I would like to build and maybe publish the forms so I can view them outside of Access. how do I ...
1
vote
2answers
8k views

How can I get a list of fields AND respective tables used in an MS Access 2010 database?

I know this is how you get a list of all the tables in the database (and more if you modify the critieria: SELECT * FROM MSysObjects WHERE (((MSysObjects.Type)=1) AND ((MSysObjects.Flags)=0)); But ...
2
votes
1answer
1k views

How to automatically create Excel graphs from Access data [closed]

I have some data in Access from which I have to create Excel graphs every month (data would also be updated every month). So it's creating the same charts with different data every month. Is there a ...
2
votes
1answer
714 views

Is it possible to create groups of objects in Access 2010 forms?

I have a form with 3 option buttons, and about 50 labels, textboxes, and buttons. Is there a way I can group some of these objects so that way when I select an option, some of the objects get disabled ...
0
votes
1answer
732 views

Open an Access database with scripting disabled (macros and VBA)

Suppose you want to examine the contents of an untrusted Access database. It seems there should be a way to open it in Access with macros and VBA disabled. Searching around the web, I've found ...
1
vote
3answers
5k views

mdb files opened in 2010 lose VBA code references

Disclaimer: I just got back from some sick time, haven't seen the error myself or investigated the full range of possible causes, just looking for hints on what may be a systemic issue or something ...
1
vote
1answer
396 views

Specifying worksheet name required when identifying a cell by name in Excel 2007

I don't know if this is a change in the version, but in 2003 this used to work in Access VBA: Dim xlSheet As Excel.Worksheet xlSheet.Range("RangeName").Value = 100 Previously I did not need to ...
1
vote
1answer
6k views

Windows 7 (64-bit) compatibility of VBA/Excel and Access applications

I am currently investigating the possible issues when migrating from Windows XP 32bit to Windows 7 64-bit. The scope is MS Excel (32-bit), MS Access (32-bit) using VBA/Macros addins, ODBC and all ...
0
votes
0answers
160 views

Retrieve selected groups of field from an Access table using VBA

I am using VBA to connect Access DB to Excel. I want to select a specified group by default. How would I select the specified group fields in the table if I am unsure about their field names?
0
votes
0answers
186 views

Help with Ms Access 2007 Combo boxes

What's the most efficient way to "chain" combo/boxes in an Access 2007 form, so that the result of the first affected the contents of the second? I already know how to associate a combo box on a form ...