Search results for query: *

Hello, I wonder if it is possible to "freeze" the columns I use in a subform. I want to block the user on modifying the used width of each column, to make sure all supposed columns are always on screen, and not moved by some end user. Regards Peter

Hello, I was just wondering if you people know some good usefull (FREE) ICON libraries to be used for an administration/invoice application. Just to make my application look a bit flashier than the regular Access icons. I found already a lot of payable libraries on the Net, but I'm sure free...

Hi, In my application I use some macro's (still have to convert them to VBA) to export tables to another mdb-file. THis mdb-file should be transferred using a 56k dial-up line. The transfer itself is done using PCAnywhere. TO speed up things a bit, I'd like to zip my mdb-file before...

Hello, I was wondering if someone has examples or info on how to create an Access application form using the Outlook-bar as an example. The bar on the left should be considered as a menu to walk trough the entire application. Regards, Peter

Hello, I have a listbox on my form which allows the user to select a payment method (eg. cash, visa, mastercard,...) I've pasted 3 small images on my form, made them invisible. What I'd like to do is make one visible based on the selection made. As such, the payment method will be emphasized...

Hello, I was wondering how to "password protect" a form in my application, based on a table "users" which contain username and password. At first, opening the form as read-only is fine; however, is it possible in this scenario to "block" certain fields from editing based on which user logs in...

Hi, I have a continuous form which shows the following data for example : Order Item Product description 2019 1 123 test product 2019 2 456 test product 2 2020 1 789 test again I want to make a visible distinction between the different...

Hello, I was wondering if it is possible to create a switchboard on the left of the screen with refers to all other forms; just the way Outlook works. Regards, Peter

Hi there, I have a form on which I have a tab control with 2 pages; one is used for main data, the other one for detailed data. If on my form a checkbox "detailed" is not selected, I want the "detailed" Page be disabled as well. Regards, Peter

Hi, I created a button to do some tasks on my form; When I cancel the action, I receive the following error message : Run-time error "2501" The action was canceled. How could I intercept this error and show the user a different errormessage which I create myself... Regards, Peter

Hi, I have a small invoice application with a form and a report to enter and display my data. Is it possible to prevent both form and report from being updated with new data ? What I mean is : For each month, I have an "hourly rate" to calculate the amount of services hours to be invoiced...

Hi, I'm developing a basic invoice system in Access 2003. The invoice data is entered using a productcode from table products; automatically, product price and description is shown in the form (duh!!). What I want to do now is give the user the possibility to modify the product description if...

Hey, I have the following tables / data : tbl_invoice: invoicenr customer date discount 1 ALF 15/10/2004 5€ tbl_invoicedetails: invoicenr product price 1 123 10€ 2 456 10€ when I make a totalreport of all invoices...

Hello, I was wondering if it possible to have the user specify the upper margin using an Inputbox, and set it using VBA. I have a customer with preprinted paper of all different sizes, and he wants to select where the first line of the report should start printing. I know this is easy to do...

Hi, I'm using a table with stock quantity numbers per product. For each product selected, I want to print labels, according to the amount of products in stock. To accomplish this, I found the following code to work : http://www.tek-tips.com/viewthread.cfm?qid=195594 This always worked great...

Hi, I was wondering if someone could guide me how to use my external contacts in Active Directory as some kind of addressbook in Lotus Notes. This to avoid creating the addresses on 2 different locations. Im using Notes Server 5.09 Kind regards, Peter

Hello all, I'm developing an invoice form, where you have to enter the productnrs (which is bound to tbl_products) as only field to compose the invoice. This always worked fine, as all products have a number. Now, I'd like to add "free text lines" for which I don't have article numbers. It...

Hello, I was wondering if somebody has some piece of code how to create some kind of logging of deleted records through a form. My database is used for 3 different shops; in the main shop, when products are changed, updated or added, they get a "modifdate" flag which is used to create a dummy...

Hello, I have a form which is used as an invoice input based on a table "articles". The only info you have to give is the articlenr, which is taken from a select query, and it fills out the description and price. However, in my articles table, there is an article "general", for which no price...

Hello, I want a solution for the following question if possible : a) I send a mail to a distribution list address, and want to get a delivery receipt, only from the DL, not from all members in this list. (I found the answer to this one : you can specify the "NOT to send delivery...