Search results

Can anyone tell me how to exclude hidden files when using FileSearch?

I know this is an ancient post, but did you ever get an answer? I am getting this error message at the "end function" line. It's really irritating, as the error handling for the function doesn't even seem to be able to trap it, so the whole db crashes every time.

Hi, I was trying to customize a toolbar by adding the "size to shortest", "size to narrowest", etc., stuff from the format menu. The first item, "size to tallest", I just clicked and dragged from the format menu onto my toolbar, and that worked fine....except that it disappeared from the format...

Not sure I understand what your code is trying to do. When would "if user<>user" ever be true??? I handle this (figuring out who's logged in) by adding a record to my "runlog" table every time anyone logs in or out. Then I just look for who logged in but didn't log out.

Just use a make-table query. Use a string function in the query to separate out the data into the columns you want. Not sure I understand your example -- are you saying that the field delimiter is "/"? If so, you can use the instr function to find where the slashes are located, and then the left...

I regularly make copies of BE's while users are logged in. It's not the absolute safest practice, but I've never had a major problem occur. If you were copying while a user was actually in the act of editing a record, you might lose the changes to that record; depends on how you have your record...

It looks to me like all you're "cancelling" is the update, so of course the form proceeds to close. I think you need to change your close button to include an if statement, something like If myupdate()=true then docmd.close Then create function myupdate() to return TRUE if everything gets...

My users run access run-time from a citrix terminal server. I have code that collects the windows user name and PC name everytime someone logs in or logs out. (I'm using Dev Ashish's functions fosUsername and fosMachineName.) This is a great help in tracking down problems when they occur, helps...

Thanks, I guess I had forgotten (if I ever knew) about the "column" property of the combo box. Any ideas on the 2nd part of my question: I realize I could do this by using a separate combo box for [Category], to first limit the contents of [Item]. But my form is a continuous form, and this...

I have a combo box with three columns, something like: Category Item ID AOI broken 27 AOI no staff 32 SMT fat 1 SMT lazy 2 SMT short 3 TP awake 7 TP bashful 42 TP...

Hmmmm..... well, I had a very similar function which I wrote several years ago, but could never get it to work without giving the users admin permission. But maybe it was before I converted to Access 2002? At any rate, I'll give it a try again. Would sure be nice to not have to wait for the db...

I would love to run the compact on close only when the db exceeds a certain size. But, I've tried this before and in order to make this code work, I'd need to give my users all admin permission to the db. That is, I don't think you can change the compact on close setting without having admin...

I keep getting the error message "Table TempMsysAccessObjects already exists" when I try to compact/repair my database. The only help I've found in the MS knowledge base just says to delete the table. I keep deleting it, but it keeps coming back. I've tried the decompile cmd line option, no...

I may be losing my mind..... right after I posted this, I checked again and it seemed to be working right. At any rate, here's what I found out: Doing it this way doesn't work: DoCmd.OpenForm "msgboxauto",acdesign,achidden {change the message on the form, etc.} docmd.openform...

Hi, I want my code to open a form, then halt until the form closes. I thought that opening the form in dialog mode would do this. However, for example, when I run a test like: DoCmd.OpenForm "msgboxauto", , , , , acDialog MsgBox "This is the regular msgbox" Both the msgboxauto form and the...

I have a filesearch set to search a bunch of folders and subfolders, as follows: fs.lookin="m:\pcamain\public" fs.filename="*_part_use.txt" fs.lastmodified=msolastmodifiedthisweek fs.searchsubfolders=true fs.execute This works fine, and runs in less than 60 seconds. But if I change the...

Do you mean you want to delete all the data from all the tables? Or what? You want the user to be able to do this? (Are you sure????)

Thanks, sounds like what I was looking for. I also found that the "f2" key seems to select the whole word in the text box; can't find this actually documented anywhere, but at any rate it seems to work with sendkeys.

Hi, I want to have the entire field in a textbox selected, automatically, everytime the control is entered--- so the user can just begin typing and automatically type over the existing data in the textbox. How do I do this? I thought it would be as simple as adding something like the following...

Let's say I have a query like: select [x]+[y] as A, [z]*[A] as B from MyTable. I have found that sometimes this works and sometimes it doesn't, (Like, it works the first time I run it, but later quits working....)so I've gotten into the habit of repeating my calculations and writing it thus...