Microsoft Access / VBA Forum

I have a table instrumenten (INSID Instrumentname, CATID), a table Categorie (CATID, Categorydescription), Netten (NETID, description of net) and a table (kpltblinstrument) that links the instruments to a specific net (NETID, INSID, amount). I have a form which displays the name of the net and it holds a the subform from table lnknetins. I...

Here is my problem. How can i make a field in a form change to a value 1 every morning when I turn access on, when the date changes? And how can i make a button on a form which would open another form and increase the value of one field by 1. The first value of that field would be 1(from the morning and increasing through the day) and it...

Having trouble getting the right sql query. I have several tables: students (information about the students) - id, Name, Grade, 123456, John Public, 09 654321, Mary Smieth, 09 candidates (information for student elections) - name, office, col

Hi Access 2000 sp3. We print a report on OKI 3391 ML (actually using the Epson LQ-1050 driver) with a custom form size. Recently we re-did the dell pc that the printer is connected to using the original win xp disk that came with the pc. Since then the report printing has developed the following problem; The report prints parts of report...

Let me preface: I'm a novice, and have no programming experience. I have created an access database and have a few tables in it. I have created a form called "clients" This form opens up and has alot of basic client information in it, nothing fancy, no code (other than what access has put in). I have created a second form "newVisit" ...

I have an existing frontend, connecting to a .mdb to a folder. Now I am wondering whether it would be wise to move the tables in the backend to a DBMS. A colleague tells me that in that case, we have to rewrite all our actionqueries. Select queries would just use the linked tables in the tables screen but all of the actionqueries would...

Hi, Does anyone know of an updated AppUser utility? I'm referring to the one that can be downloaded here: http://www.mvps.org/access/api/api0062.htm Reason asking is that it says 'Please note that these are NT/2000 only API functions.' I'm unsure if this would have any effect on me assuming that note was referring to Windows version...

Sorry the original message was posted to more than one newsgroup (at different times) due to problems our end. -- Craig Alexander Morrison

On my main form, frmCompanies, I have a tab control with two pages, each page having a subform. One of these subform has it's own subform, and on this subform is a command button, cmdGotoCand. When this button is clicked the following code runs to close the main form and open a new form. It always gives me a fatal error. If I do the same thing...

hi ! i have designed a data access page and it works fine connecting to the database on my computer but when i change the connection to connect to my database on my web server it wont connect.the database on my website works fine with connections using Frontpage but wont work with a data access page ?? thanks

Hi! I'm quite new to using SQL in Access and I therefore need some help wth the following problem: Lets say I have all my data in one table to simplify things and I want to create a SQL Query that goes as follows: "SELECT AVG(myTable.myValue) FROM myTable WHERE EXISTS(SELECT TOP 10 PERCENT myValue FROM myTable ORDER BY myValue ASC WHERE...

I have code that formats an excel report. Most of the time this code works; however, sometimes it bombs out at the statement: With XLApp.ActiveSheet.Range(rangedef) .Select ActiveSheet.Paste .Copy .PasteSpecial Paste:=xlFormulas, Operation:=xlNone, skipblanks:=False, Transpose:=False End With

Hi, I am trying to set up a DB for a race series where a riders best 6 of 10 rides count towards a league position. I have a table of Riders ( say 300 ) I want to use a form to select which riders from the Riders Table are taking part and create a new Event Table ( say Round 1 ) max of 120 riders per event.

I want to buy the latest version of ms access. Will this version let me create an mdb that will work with a lesser version such as 2000, I am having a problem going from 2002 to 2000. The mde will not work. Is there a place you recommend that has it for a decent price? Thanks

Any suggestions on how to get this to work: My table includes a index that requires three combined fields to be unique. However, sometimes the third field will be null....thereby excluding the record from the uniqueness requirement. Details: tbl_Product_Licensor Product_ID Licensor_ID

I have a user who is having a problem with an access database that I didn't build and haven't had anything to do with in the past. The database opens up to the switchboard, and she clicks through to the "look up by facility name" form, and opens it up. So far so good. She is able to click on and view every single thing on this pretty...

I have MS Access 2000 running on a laptop with Win XP and I am having trouble getting users to have access to some databases. I have two databases that seemed to need repair so I used the repair utility and it worked, but I now find that the Administrator can access the databases but users cannot. The message I get is that permissions are...

I have a table that is an autonumber field. This table appears as a subform in another form. I want the ID# to show in the subform...but I don't want the (Autonumber) to show at the bottom of the subform. Is there anyway to prevent the last field in my table that has the ID (Autonumber) from appearing in the sub? Thanks! Chris

Hi All, In the desktop shortcut I added the /ro switch to the command line \\Homf6\Vol2\LifeComp\ComonDbs\AVA\Apps\AvaXP.mdb /ro and the db opens but I can still change data that is displayed on a form. So, what am I missing?? If the "/ro" switch is suppose to open the db as read-only then why is it letting me change data thru a...

I am looking for some ideas for how to design the layout of the form for data entry and to display the data for the following situation: There are many sales associates. A sales associate can work for multiple companies and work for multiple divisions within each company. Within each division he can work in multiple departments and within each...

I have a field containing thousand of vehicle number plates like these: SBP3432D SCX845T EP2X QM45G S1P how can I delete all the suffix at one go so that the result will be:

This is only a test. Thanks

Dear Sirs, I selected one mask on the DB window, and right click I chose "hidden" option. Now I would like to get back visible such mask, how I can restore (visible) such mask on the DB window? Thank you for your cooperation

Access2002 (10). Every time that opens a form, in the Windows application bar, to appears a new icon, like if it were a new one task. It's possible to avoid that? Thanks for any Help

Using Access97. Right Click on a small table and try to Save_As/Export. Excel is not listed as an option. I can however... click a Table then click the Analyze With Excel button? I have uninstalled/reinstalled several times. Any help appreciated. TY