Search results

Is the question too strange?

Hello and nice weekend to all, I would like you to teach me something if possible. when I use If MsgBox("Would you like to save now ? ", vbYesNo) = vbYes Then ... Access opens a dialog box with 2 buttons, Yes and No. Now my question. Is there a possibility to change the caption of this...

I am... astonished with the beauty and simplicity of your approach. I am still smiling. I thank you I dare to ask part 2/2 of my question. Now that I can see the total for each of my pages, I would like to have that same total on the top of the next page. Transporting that total to the top of...

Hello Grand community, I have a problem, I seek your advice I would like to know how can I calculate totals per page. Ex: I have some items that span across 10 pages, but I would like to be able to show in the paper I printed to my client, the total per page corresponding to the itens showed...

Bob, I understand now what the problem is :) You wont believe ehhehe Your function was not working because I deactivated the ALLOW FULL Menus on the STARTUP submenu on the TOOLS options on the menu bar... With Full menus activated, obviously it works... and beautifully the problem is that I...

I did... now nothing happens... no error message, no compact Very strange bc I understand the procedure. (Sending the keys) oh, well.. sorry to bother you for so long...

Bob, I created a module called CompactData. Inside, I created the procedure Public Sub CompactData() DoCmd.Close acForm, "About", acSaveNo SendKeys "%(TDC)", False End Sub On my form About, I created a button Private Sub Command16_Click() CompactData End Sub and it...

Hi Bob, thx for your help, your approach it's so much easier BUT again, my lack of abilities prevent me from doing the right move. Whem I put your code(s) on a button, and click it gives me the following error You can't compact the open database while running a macro or Visual Basic code...

Invalid use of property Hi Rickster57, many thx on your help, but I am making some mistake along the way... I copied the code on the page to a module, then I created a button called Bot_compactDB. Inside I put the code CompactDB ([name of table]) and it gives me an error - Invalid use of...

Hi, I have 2 files db_main.mdb db_tables.mdb 1 - Can I create a form with a button on db_main.mdb that will compact (and repair) db_tables.mdb without any dialog box or without going to the menu? Thx in advance for any help. Cheers

Problem Solved, thx 2 a good friend of mine... OK... uff A good friend of mine just solved my problem (and potentially for others) with a page fom Microsoft... here it is if something similar happens to you... http://support.microsoft.com/kb/247979 "RESOLUTION The Microsoft Scripting Runtime...

Hello Grand Comunity, I am in need of your assistance I don't know what happened between yesterday and today but a rather strange problem occur everytime I try to open a form of a database I am creating... Side note: Using Access XP When I try to open it it opens a dialog box saying Runtime...

I am now studing the code, the progress bar is indeed very helpful.

Dave, wow.. this is fabulous... exacly (in terms of funcionality) what I want. Kind of complicated for me at my stage, but I will study it. Many, many thx

Hello all, 1 - I'm creating a database splitted in two: The front end with forms, queries, reports, balbla; and a mdb where the actual data and tables are. On the welcome form I have a code to read inside a INI file I created that reads where the DATA.mdb is. IF the DATA.MDB is not on place the...