Forms

using VBA to change property of a field
hey, im trying to change the 'control source' of the field "balance" from the form "HSBC Form" at the click of a button... here's my code so far: Private Sub Command13_Click() [Forms]![HSBC Form]![Balance].ControlSource = 6509 End Sub when i click the button it comes up with the #Name? error, any t... 4 Jul 2008 15:08

Search Form to search everything
Here is a silly question. Is there an easy way to enter a single search term in a text box and have Access search every field (control, etc.) for matching results "automagically" as the saying goes? Some sort of wildcard, maybe? For example, a user enters a Driver's License # or a last name. Access then ret... 2 Jul 2008 20:08

Cascade 13 Combo Boxes...
Im new to Access, but heres what's going on: I have a Spreadsheet with about 13 columns, each column a different specification for offshore drilling rigs. So i have 13 different combo boxes. I have set up a form with 13 combo boxes, each pertaining to a column in my table. The first three combo boxes are Rig ... 7 Jul 2008 09:24

WHERE help with preview button event
Thanks in advance for your help. I posted this in the queries forum but thought it more appropriate here. Two things happen when I click my preview button: - If I make a selection in the listbox the report opens BUT every field is either blank or contains #Error. I placed a textbox called OpenArgs (and if you're... 2 Jul 2008 22:11

List Hangs when selecting all Items in list (See Code)
Hello; I have a list box ; I use the below code to select all, or clear all similar code . It works fine so far, but when I have a list returning 13000 records. It hangs. Any ideas. Thanks in advance. Roger ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Private Sub cmdSelectIssue_Click() ... 2 Jul 2008 17:03

HELP with two tables and Loop question
HEllo i am having troubles doing some kind of program, i want one to check another table for begining to end. Something like this: While (Barcelona.ABPOBL) While (Pueblos_temp.Pueblos_temp_1) WHERE (((BARCELONA.ABPOBL)=(Pueblos_temp.Pueblos_temp_1))) SET (Barcelona.PERTENECE) = 8 Want to compare the first ... 2 Jul 2008 23:12

Break Occuring with no Break Point
I'm not sure what's happening here, but a break is occuring with no break point in sight. I'm using Access 2003. The database is used by one person. I was asked this morning to make a couple of cosmetic changes to a spreadsheet which is the output of a macro. I did so and tested and all looked fine. I set some... 2 Jul 2008 18:05

fill excel with format
I retrieve data from MS Access and fill Excel spreadsheet. After data filled on the spreadseet, The border of spreadsheet does not change accordingly. For example, the spreadsheet has a bold border on the result area for 100 rows. If the records returned more or less than 100 rows the border still keep for 100... 2 Jul 2008 18:05

date format
I have a form that gathers a job type. If the job type is one category the date format is mm/dd/yyyy but it is not format is m/yyyy. Code if type_of_job.text = "TE" then start_date.format = "mm/dd/yyyy" else start_date.format = "m/yyyy" end if The problem is that start date is not placed into the un... 2 Jul 2008 18:05

ARRAYS
Array question: I want to match an account number entered in a form to the same account number in a transaction table by looping through the transaction table and for every match (the number of matches can vary) extract the date and amount field and load the date and amount into an instance of an array. Can some... 2 Jul 2008 20:08