Search results

Says "Invalid procedure call or argument"

Public Function OpenDatabase() On Error GoTo Err_OpenDatabase Dim database Dim turtlemeter As String turtlemeter = "s:/AccessDB/Turtle_Meter" database = Shell(turtlemeter, vbNormalFocus) Exit_OpenDatabase: Exit Function Err_OpenDatabase: MsgBox Err.Description...

Is it possible to open a database from a form in a different database? Not necessary to do so; it would just be handy to do from the form I already have up and looking at rather than having to go open another instance of access and go to that database.

That helped greatly, thanks Alc

I would like it to come from a macro because I already have the macro built and its fairly complicated. I am fairly new to access and have just started really using code instead of umpteen thousand macros and this was one of the first ones I made. It doesn't really matter though because I can...

Either way they're taxing it on both ends. It's just not right.

There is a command CompactDatabase in the DoCmd.RunCommand action. I tried to use it in a macro to compact my database every so often but it gave me an error saying that you can't compact a database from a macro or VB code. My question is, what is the point of making this command available if...

A kid at Christmas, happy as a two peckered billy goat.

Aweful!!!!

I figured it out. Thanks for the help Bob

Then maybe the better question is this. I have a form based on a table. What I want is a search box that will locate the record based on an account number and pull it into the form. I have buttons for navigating to the next and previous records but nothing that will search and find. I've tried...

Can anybody tell me why this SQL statement won't run in in the RunSQL macro action. SELECT Open_Issues.* FROM Open_Issues WHERE ((Open_Issues.Account_No)=(Forms.Open_Issues_Viewer.Text64)); It tells me that the RunSQL action must have an SQL statement for an arguement when I try to run the...

Why don't dogs carry money? . . . . . . . . . . . . . . . . . . . . Because they don't have any pockets!

I believe this is the worst joke EVER! You deserve an award for that one

I guess I'm still confused on what you are trying to do. Are you wanting to start at the top of the table and add track lengths until you go over 900 then return the first x tracks before you went over?

So how do you cut things, anything?

Add all of your fields to the query and in the criteria for the "length" field add <900. If you want the ones that equal 900 then use <=900.

If you've never heard of these guys then you obviously don't know much about racing in general.

Montoya, Carpontier, Franciti. And they suck at it because they can't DRIVE a car. Sure its easy to turn the steering wheel in those tiny, low to the ground cars and drive with the accelerator. Its a whole nother thing to get up on the wheel and actually drive with the steering wheel and set the...

If NASCAR is such a pussy sport, then why are your top teir F1 and Indycar drivers wanting to drive in it so bad? And I might add, THEY SUCK AT IT!