Search results

I have a bunch of queries put in 1 macro. Of course, some queries have the same parameter [Enter current monthend] so when I run a macro, there are few popups asking to [Enter current monthend]. It’s annoying for users to put in the same parameter 2 or 3 times for a report. Is there a way to...

:confused: Hello, From my workstation, I tried to set user-level security for 1 of 2 db in a shared folder (which I never set up this before). I set up the user names and passwords for db1 only but the when I opened db2, db2 also popped up the logon box. 1. I want to setup the users' accounts...

Hi- Can Access allow more than one users to run the same report at the same time? If so, how can I set up the database? Thanks.

Hi- I created a report which has a textbox containing a calculated value (audit amount) from many calculations/conditions. I need this value to be stored somewhere. Since the query is not simple, I think I may try to have this calculated audit amount stored from the report instead. Is it...

Hi - I'm trying to create a list box where a user can select multiple items from the list box... Please advise. Thanks a lot.

Hi, I would like to have a query where the user can enter a few letters and can pull data containing these letters and related fields... Ex: User enters 'west' to pull all data in that field containing 'west' such as 'westland', 'eastwest'... select * from a_tbl where b_field like '*[enter...

Hi, I want to create a report showing 'From:' [date_posted] 'To:' [date_posted]. The users will enter: ex: 12-01-01 and 12-20-01 which exist in the main_tbl to inquire info in that time frame. This is the query: SELECT location, sum (amount) FROM main_tbl WHERE [date_posted] between [Enter...

Hi - I would like to have a column in a report grouped as 1-100, 101-1000 and 1001-up (not interval) Pls show me how to do it. Thanks.

How can I make the list in Combo Box sorted ascending...? Pls help. Thank you very much.

Pls show me an idea how to make a list box from which value selected will pull all related fields... Thanks so much.

How do I write codes for a MsgBox with vbOKCancel? This is what I want: when I click Cancel, nothing happens. When I hit OK, exit db. Pls help. Thank you very much.