Search results

Hi there, I need some help with referencing controls, I have a Report with a textbox that I am using to show which Option has been selected from an Option Group on a form. The only way I have been able to do what I need is using a hidden text box with the following code...

Hi there I have a form and subform with one to many records derived from 2 tables and I'm using this as a source to populate Formfields on a Word document. I am using a VBA script I found and altered linked to a button on my form. Problem is only the records from the Main form window are...

Hi there I have searched and searched but to no avail, My question is can I use DMax() to add a Sequential Number to the end of groups of Strings. My Field is Datatype String The data looks as below I would like to add -001 -002 -003... to each Group A-B1-1-330-01 would end up like...

Can anyone please tell me how I can place a select case statement in a module and create a function and call it from an expr: field query expression in a select query? I have a select query with an existing field [Responsibility] and I want to use that field to populate another field that will...

Hi there, I have an update query that will not update fields that were previously blank. Is it possible to populate these blank fields in the query grid criteria field to "-" and then run my update query?

Hello Can someone please tell me why my Select Case statement isn't working? or point me in a better way to achieve my goal. I previously posted this wrongly in the forms forum but I think it belongs here and I apologise. The [ClearanceDate] Field contains Dates in the form of a Text...

Hi there I searched the forum but drew a blank, Have any of you ever created an Access Database with a Form and report that can be used to produce RACI reports or Deployment flowcharts? I would like to store business processes and the individual steps that they are made up of and record...

Hi there I'm struggling with the code below, I followed the instructions but I am getting a Parameter Query request "Enter paramater value" SortOrder. when I try to type a character into the combo box. I followed the instructions below <LI itxtvisited="1">Create a combo box on a form. <LI...

Hi There I have an 2 tables that I am comparing and an update query and it works well when I use it to update changes from my tblUpdate to tblMaster I've even manage to have the records that have been updated marked with "U" in a field called Flag. But what I would really like to have is a...

Hi there I have a strange one here, I am producing TOC's for a number of dossiers using Access as my database and then outputing to a Word doc. the process seems to work fine and all of the documents are produced correctly, I can open one and view it and the book marks are filled with data...

Hi there I'm trying to write a query using an IIF statement in the "Field" property of the Access Query Design Grid the new Column is called F: there are 3 Columns, System, Etot, Itot in a mytable Basically in English the query goes, IF mytable.[System] = 700, mytable.[Etot] = 0...

Hi there I am trying to use a list box and multi select from it as a source to enter data into a bound field in a table. I found what I thought was just what I need but I keep getting error 424 object required! The list box is on a form bound to the field [comments] that I want to update. The...

Hi there I have a spreadsheet that I have successfuly imported into Access but now I would like to maintain it, update/append/delete records etc. The spreadsheet is produced weekly and Intend to import it into my Access database on a weekly basis there are around 20,500 records and 15...

Hi there Is it possible to change the ColumnCount of a combobox using VBA? I want to have the Filter2 combobox listed below to use the column to it's right to give me the "Description" of the Item that is selected in the Filter2 and then this text will be output to my report as below...

Hi there I am struggling with the correct syntax for using "Is Null" , "Is Not Null" and "" when using them in a variable to pass back to an Access Query I have code, just a segment of a query below using "Is Not Null" Dim strmystring As String strmystring = "Is Not Null" Only problem when I...

Hi there I am trying to use 2 option groups both having 3 radio buttons to filter the rowsource of a combobox, I was thinking of using 2 sets of Case Statements but do any of you know if this would work or is ther another way? It is a case of the user can select one button from either group...

Hi there I have managed to import a spreadsheet from Excel to Access using a command button on a form and adding the code below to the onclick event. And it works well but:- The spreadsheet table1.xls I use is updated frequently! how do I go about dropping the data in the Access table "Test"...

Hi there I hope one of you guys can help me! I have a Table or Query and it contains data as below FIELD_1 | FIELD_2 AAAA____|1111 AAAA____|2222 AAAA____|3333 BBBB____| 5555 BBBB____| 9999 How in a form can I display the data as below not using cascading combi boxes but using Text Boxes, the...