Search results for query: *

Hi, I'm trying to provide a code for compacting by BE. So the idea is to doe the following: 1. make a copy of the current DB just as a dummy 2. connect to the dummy in order to free the current DB 3. Compact the now freed current DB 4. Then reconnect back to the now compacted DB and then kill...

Hi, I'm using the code below on my spalsh form to giving permission to the folder in the folder that houses my FE and BE. This only runs, the first time the application executes on a computer after installtion. Seems quite straight forward, but it does not work. It works when I install...

I have an access app I recently started to develop with nicely done FE and BE. My client however is worried that with 10-15 concurrent users generating close to 150 transactions per day will cause the database to start acting funny acting funny after a couple of years. He prefers an SQL...

Hi, I'm working on a database for a client which I intent to offer on a "per-user-logged-on" license basis. So for instance he may create 1000 users if he wants in the users table but only 5 for instance can logon concurrently because thats what he paid for. What is the best way to go about...

Ref: thread705-999475 This thread seems to be exactly what I need to backup my back-end but when I compile the code I get a "User-defined type not defined" error on: Dim fso As Scripting.FileSystemObject Am I missing something? Also if my back end is password protected, how can I tweek this...

I have this piece in my code in my split program: Dim db As Database When I compile I get an error message that says : Compile error: Expected user-defined type, not project" Can anyone please help with this?

Hi All, I have a form that is link to a table. On the form, when the user presses the ESC key in the middle of entering a new record, the entire record is canceled and the form resets to new. But I actually have a "Cancel" button which then asks the user to confirm the action before going ahead...

I have a program that I have split. It works fine because I dont have to move the BE (yet). If I ever do move the BE to another location or to a different server or for some reason I need to connect to another copy (e.g. backup copy) of the same data base, how do I go about?

Hi, I have tried to search for solutions to this problem but I keep getting solutions for Acess 2003 and below which does not work for me as I am using 2007. I am trying to open the file dialog box using the FileDialog method. I get an error on the first line where I declare my variable (fd) as...

Hi, I am using the code below to upload images to my custom controls on my custom ribbon in acess 2007 but I keep getting this error message no. 481 "Invalid Image". When I try with a .bmp file it works but all my images are in .png fromat. How can I get around this? Function...

Hi, I have just started using access 2007 and recently learnt how to customize the ribbon using XML. What I have not figured out yet is how to disable the Office Button so that users cannot have access to any of the items on that menu. Any ideas?

Hi, I migrated from 2003 to 2007 and access 07 does not seem to recognize the filesearch function. Infact the DLL responsible for this function which used to be located in Office11 is missing. Even when I copy it there and try to add it to the references it still does not work. Has the...

Hi, I have just began my migration from Access 2003 to 2007 but one thing that has beaten me till is how to create a new custom menu bar and add custom commands to it. Thanks

Hi, I am trying to copy a file from one location to another. I found this code in VBA help but is returns an error that says object required. Public Function CopyFile() FileSystemObject.CopyFile Application.CurrentProject.Path & "\ldc.dll", "c:\Windows\System32\", True End Function Can...

Hi, Does anyone know how to lookup a computer's physical/mac address from VBA. I need to make sure that once my program is installed and registered, the database cannot be copied and used on another computer. Or is there any other way I can prevent my program from being illegally copied from...

Hi, I have been trying this for a while now and it just occured to me someone may already have a solution. I'm trying to create a custom calendar or at least customise the existing calendar control in such a way that it can read data from a table of agenda for example and display little icons or...

Hi, I have a custom menu bar called "MyMenu" which has some drop down menus like "Customers", "Vendors" etc. Under each of these drop down menus, I have a number of controls For instance under "Customers" I have "New Customer", "New Invoice" etc. I used the following code Dim mb As CommandBar...

Hi, I found an article on how to disable menu items whic has been helpful but what I want to do is disable or enable particular commands specfic drop down menus on my custom menu and not the the entire menu.

Does anyone know how to retrieve the Mac (physical) address of a computer through code? Thanks

I have an invoice form that has a button that opens a list of products for selection. The thing is, I would like to open a products list form relative to the position of my invoice form. ie wherever the user moves the invoice form to on the screen, when the products list opens, it opens at the...