Microsoft Access / VBA Forum

Hi all ! I need to find a good tutorial about VBA and Access. Thanks

Hi All, This might quite simple process for some but I am finding it really difficult to do. What is required is not a standard Duplicate query but a variation on it. For example I have following records: ID_Number Date Name Amount 100 1/1/02 Andrew $100.00 101 1/1/02 Andrew ...

I would like to add filter functionality to my database whether through the Main form or the subform. This question may be rudimentary, yet I have not less experience with filtering data outside from queries. Let me just add that Allen Browne excellent article about this subject may not apply to this scenario on an elementary level. (Here's...

After running some code on some forms and in some modules... I am getting stuff like this in the immediate window... 9 9 9 9 9 9 9

Hi all ... I have an Access XP application that works fine at 8 separate locations. The 9th location however has all sorts of strange things happening. For example, as a test, I created a new database and made one form with 2 textboxes. I added the following functions behind the form: Function SetBack()

A long time ago, I recall seing an Access website that had code for kicking users off a shared database. Could anyone point me in the direction of that kind of code?

I have a form with 4 text boxes; the data that is entered into them are as follows. Text1= Start Time Text2= End Time Text3= Date Text4= Interval I need the form to populate a table with sequential times based on the start/end times, interval given. Then attach the same date to each record.

When I wrote up a module to display the Windows Print Dialog box (to allow the user to select a specific printer on the network) instead of the DoCmd.OpenReport the function worked fine. I packaged it up in a *.mde file to send to the client and suddenly an error popped up when I ran the function: "The command or action 'Print" isn't available...

Can anyone tell me how to keep a sub report together on the main report. Once I drop the sub report onto the main report all of the sorting and grouping keep together options on the sub report go out the window, and the main report doesn't seem to have anything that I can find to move the whole sub report to the next page if it won't fit in...

Hi In Access 2000 I have the following code; Set dbs = CurrentDb <some code to access database here> Set dbs = Nothing

I have a database that I thought had fairly tight security applied to it. It's in Access97. I'm running it also on a couple of machines that shipped with Access 2002. This is probably not a good idea, but to avoid rewriting the application I put A97 on the new machines and setup my usual wrkgadm.exe to the .mdw that everyone else was using....

Can anyone tell me how to convert a macro to a module?

Does anyone know how to set the Sort Order for a Pivot Table when you want the data to be sorted on a field that is available but not placed on the Pivot Table. My situation is that I've got these text based catagories that have Sequential Level numbers. The catagories are on the column axis, showing up alphabetically. Not what I want. I'd...

Guys, Got a bunch of DBF files all named pikcup.dbf. They are all stored under a directory named c:\reports but are all under multiple sub directories. I need Access to import all pickup.dbf files into a single table. I have no idea where to start. Any ideas. The Pig

I would like to setup a form that will log the users logging in to a db. The form and the Db will currently log the users if they complete the logon and get in. It will then log the entry, but not if they fail to login. If they fail I would like it to log the attempted pass and the computer name from where they are logging in, the systems...

Here is the setup There are three Machines all running Access97 & XP Pro \\readingtill1 \\redingback \\redingtill2 on a LAN And four dbs

Hello Tom, Long time listener, first time caller... I have been working with vb code to automate a salary increase process that not only rounds to the nearest penny but also rounds to the nearest even penny using the code that follow. The problem I have is that once I set the even rounded value back to the text field it adds a 01 on the...

HI, Excuse this new question, I am trying to impress my wife by putting a db together for her dance studio. I put a table with all students new and old with fields including name and address and than a series of fields each is a yes/no for a given offered class. On the form you just check the class or classes they are enrolled in. My wife...

When I open my form, I want the records already in it to be in Ascending Order based on one field. Though I keep putting them in Ascending order and then saving the form, each time I re-open the form, they're out of order. What am I missing here?

For some time, I have been using TSISOON90.dll, a free Access COM Add-in from Trigeminal Software which closes one db and opens another, plus other useful tasks. We recently installed some new WinXP Pro machines. We have VBA code in an Access form to run regsvr32.exe to register TSISOON90.dll. When I am logged on as admin, this runs fine...

Dear All, I designed carefully a reasonably complicated report and a form. I use this form for data entry and also for searching by setting various filters on that form. What I would like to achieve is to have a button on this form which could invoke the already designed report limited to only those records which are filtered out on the...

An HTML version of this document is available at: http://www.mvps.org/access/netiquette.htm Feeling left out? Alone? Wondering why everyone's ignoring you? Or why you're being flamed for what you deemed an innocent post? The following tips will not only help you, they will help us help you. Please note: The latest changes to this...

Due to problems reading the first thread I started I think I should respond with a new post. I have been only able to read up to the 2nd clarification that I posted. Thanks to all who responded. I'll keep trying to read it. I really don't wish to waste everyones time by asking you to repost the stuff I can't read here. I just wish to let...

Hello Experts, Can you please help me out? I am very frustrated! I am trying to update import specification, and it does not let me do that. I have saved specification and now I need to add one extra field at the end of the file (importing txt file). I open the saved specification than add new name of the field and its specification,...

Can I and if so, how do I read Acc2003 files in e.g. Acc2000? Can I open it via ODBC? Or can I use Jet 4.0? I only need to read/write into existing tables. No developement or structure changes. -- Thanx/Rgds., Groeten, Huibert.