I have a form and subform which I want to view as a datasheet for quick
scanning purposes, Once I find the record I want, I double click a field
which runs
DoCmd.RunCommand acCmdFormView
Is there any way to hide the + sign indicating child records in the datasheet?

In Access 2000 is there a way using API calls (or another way) to get:

1. MAC Address

2. RAM

3. MS Office Versions (ie 2000, xp etc with Pro and or Std)

Thanks

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 thoughts on
why this is happening?

thanks,
b

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
returns a list of all records that have that particular name or number or
whatever. Kind of a blind search, because they have insufficient information
to search any particular field by name or whatever. They have been given one
piece of information...say for example an even more broad search...they want
to find all white females in the database. Instead of having to have these
two fields represented on the search form by combo boxes, just enter "White
Female" and it comes back with 10 records that pertain to a white female.

I hope this makes sense and can it be done? Should it be done?

Thanks.

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 Name, Owner, and World Region. I
have it working thus far to where i can use the drop down menu of combo box
(CB) 1 and choose a Rig Name out of the drop down. I can then proceed to CB 2
and it takes CB 1 info and narrows down the list to the Owner of the Rig in
CB 1. I can proceed through all 13 CB as longas i go in order and it will
work fine.

What i need to do is have this set up to where i can go in a random order
through the 13 combo boxes. I have been doing all of this without using
visual basic, and would prefer to not have to learn that program, but i have
a feeling it would be easiest in the long run.

Thanks for the help.

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 familiar with JOURNEY's 1980's hit Open Arms
you MUST chuckle) in the report and it properly displays the selected
IDs.
- If I do NOT make a selection in the listbox the report opens and
returns every PKWTID and all of their associated FGIDs.

I'm fairly sure that that this is a WHERE problem but I'm lost as to
how to correct it. The button code follows but first a little design
info.

I'm using Access 2003. The button is on the following form that has
the following controls.

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()
On Error GoTo Err_cmdSelectIssue_Click

Dim iInstr As Integer

'This is the "Select All" command button
'It scrolls through every item in the list and sets selected to true or
Highlights all records in List

For iInstr = 0 To lstInstrIssue.ListCount - 1

lstInstrIssue.Selected(iInstr) = True ' If Iset this to False it
de-select the items.

Next iInstr ************** when I debug, it is stuck here at this line

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 ABPOBL with the first Pueblos_temp_1 to the last
pueblos_temp_1, then the second ABPOBL with the first pueblos_temp_1

and so on
if they are equel i wanto to set Barcelona.PErtenece to 8

how can i traduce this to Access 2003

Thanks

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 break points while testing and
removed them when I was done. A while later my user sends me a screen
shot of the macro code and one of the lines is highlighted in yellow -
like a break. Ok, so I open up the database, click on the button that
runs the macro and sure enough, the code comes up as if a break point
were set. I was able to hit the F8 button to start stepping through
the code and then clicked the "run" button and everything went on it's
merry way. So I cleared all breakpoints...

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 rows.

Are there any way to redraw the border according to the results set?

Your information is great appreciated,