I have a small set of code which I just added a nested loop. Basically the program will loop through multiple selections and get multiple records for each selection (the nested part). I then...
I am trying to create a Printable report which will have different information on it depending upon what product has been selected.
This is my current code:
If Make = "AVG" Then
...
I need to modify the following code to allow me to specify which records to display in each of several text boxes on my report.
Dim rs As DAO.Recordset
Dim strValues As String
Set rs=Cu...
I have an Access Form that contains a combobox (Combo0), a Textbox (Text1), and another Textbox (Text2). There is a table that has a column of cities called NAME, a column of States called ST...
I have a created an excel template that is filled with VB code from access 2003. I have a chart that is coded with a specific "Case" for 5 cells in that excel template. They all have the same ...
I am working in Access 2007 and am trying to write an event procedure but my code doesn't execute. For exmaple, I wrote some test code for to execute upon the form loading, i.e., "Private Sub...
(It was suggest I ask in the VBA section.. this appears to be the closest to VBA for Access)
I'm using Access 2003. I have different reports printing on different printers. One of those pri...
Hi all,
I have a memo field that gets populated from imported Word Documents. I would like a way to strip out the special characters from the Memo field - ie Carriage Returns, Tab Mark etc....
Hi
I have two variables oTable, oField and oID
How do I write VBA code to find the record containing oID for field oField intable oTable
and open the table with that record selected
...
I need to have a function that will allow me to use lists of tables and ODBC entries to allow VBA driven linking of tables. The ODBC entries will be created before the code is executed.
I h...
Is there a way to bind an unbound text box in a continuous form to a record set? I want to be able to enter different values in the text box in the continuous form and then send the values t...
Hi,
I have a huge text file which I have split into multiple variables, and now I need to be able to put them into a table. Some of the lines cause changes in the values of some variables, a...
My old employer built a slick little tool that built an ODBC connect string in Access and then used that string to connect the Access front-end to a SQL Server backend. I know he used some op...
I'm parsing an XML response using VBA, my problem is that when a tag has no data I'm getting the following error code: -1072896659
Error text: End tag '' does not match the start tag ''
I ...
I need to compact my database on closing it. How would I code this using VBA? I tried using a macro but it just takes me out to another menu outside the database. I just want it to compact ...
I have created an Access report which gets output to Word, and once in Word I run a macro I created which formats the report.
I would like to (a) automate the process so that Access outputs...
I'm trying to write an if else statement in which the action would perform if two conditions where true.
example:
If result = 2, and time = 3, then
I have an application that links to sql tables using ODBC. The users access all the same tables but one group access them from one server and another set of users access from another server. ...
As I add VBA code to an Access 2003 module - I find myself hand-typing the following code often: Is there anyway I may automate this and if so, how? I am unable to buy the add-ins the market...
I have a MS Access 2003 form with a label named 'lblTrackingHyperlinkNumber'. The label's caption is the Tracking Number from the United States Postal Service. What is the label's hyperlink ...
I have a query that when you run it you get an Enter Parameter Value window. I want to run this query along with several others in a macro and I don't want to have to enter this value every t...
I have successfully created a Linked Server on Microsoft SQL Server Express 2005 with the following:
Server is at 192.168.0.106\sqlexpress
sp_addlinkedserver @server = 'LEDGERS',
@srvprod...
Hi, I currently have Sales information stored in an Access Data table. This table has the names of all the Salesman in the field "Salesman". I want to export this data to excel on seperate s...
I am going to go to tools-->Startup and...
disable...
"Allow Full menus"
"Allow Built in toolbars"
This is so that nothing appears on toolbar menu in my Access mdb.
Nonetheless I al...
I have two tables in Access. One each will have a string like this
County of Broward
and the other
Broward County
This is a very simple example. What I'm trying to do is find a m...
