Microsoft Access / VBA Forum

I have applied user and group security to an application where the main form uses a tab control. The tabs are things like general, salary, expenses, qualifications etc. I want some of my end users to access to this form but not have access to some of the tabs. I have restricted access to the underlying tables and the sub forms the tab...

Hello, Im doing a inform in access, so the tables is like this: People(Name,Adress,City,Phone,IdWork) Work(Id,Work) In my mailing I list Name, Adress, Phone of a city which I choose, and I want to add a list of all works because the user can select the actual work.

hi all ! i have created a list box of names for a form . the problem is my client wants to use it with a touch screen system , so the list box is very hard to use as there is about 80 names in it and you have to scroll down. this could be fixed if i could make the scroll bar larger.how can i do this ??? thanks

Hi, I am trying to create and use a recordset (based on a table) in a module. However I do not understand recordsets (in my access books there is only 2 chapters) fully to understand why i cannot get this to work and how to fix my errors. If somebody could point me towards some good explanations i would be very grateful.

I had created a database in Access 2000 before being informed by my boss, that he had thought of another field that was necessary to be included. I have had no problem putting the field into the relevant table, but am unable to work out how to add a field into an existing form. Any help would be greatly appreciated. Cheers, Chris H

Hello all, I am converting an Axs 2.0 application to a2k (I know A2K is not the most current version but Axs 2.0 support ended and A2K is supported in our company amd on every PC). The form is part of an access projcet (ADP) and runs against SQL Server 2000. I have an bound form in endless view which contains a header with a combobox....

I am using MS Access as a front end to a MySQL server on a windows platform. The problem is that when I add a new record to a list (continuous form) of records as soon as the cursor moves to another record the just entered data appears as #DELETED until I requery the form. The problem is that the record does not appear to get an ID until it is...

hi, i have following table data city region issue value c1 north i1 y c1 north i2 y c2 north i1 n c2 north i2 y c3 south i1 y c3 south i2 n

In A2000 reports being viewed open in a readable size font. In A2003, the reports open in a "fit page to screen" mode and the text is too small to read and I have to click on the report every time to get to a readable size. Is there a option to have the A2003 reports open to a readable size (i.e. not in the "fit page to screen mode")? ...

1)I have 2 forms, created from 2 tables. Patient Details and Placement details. I have Full name and address on the patient Details form. I want to auto fill the address once the full name has been selected. 2)Then I have a button to go to the Placement Details form with the field Full name on. I want to press the button on the patient...

I set the input mask for the date field to "00/00/00;0_" but instead of showing a 6 digit date such as 01/01/06, I receive 01/01/2006 an 8 digit date! Is there a manner in which I can over ride this?...In the table containing this date field? Or by way of the textbox control in which the date is entered on my subform? Thanks!,

Problem: Social Security number being used in a database. First problem is that it will not permit numbers beginning in zero to be entered - it sees it as a null or empty space from what I can tell. Next, foreign students have & as the initial part of their SSN. How to do this?? Finally, how do I force the cursor to the far left of...

Dear Sirs, I am using access 97 database and connecting to it via VB6 using Microsoft DAO 3.6. I had office 2002 after opening a report using the follwing method then after pressing escape on the report the access database used to close by itself. now that i installed office 2003 the database is still open after pressing escape.

I own a small business and we have a database on access. I need a small amount of work done and would like to find an Access Guru to do help out (for pay). If interested please email me at tim@craftproducers.com. Thanks, Tim Cianciola

Hello, I'd like to determine the size of a file via a URL. I'm not even sure how to do this on the local machine, let alone a URL. Any help would be greatly appreciated. Thanks!

Allen Browne proposed a sample database, People in households and companies, for modelling human relationships. Can someone help me with the correct method for preventing a party to be a parent or a child of itself ? Regards

Hi all, Sorry to hassle you with this query, I'm sure the answer is a simple one, but it remains elusive - to me anyway. What I am trying to do is get a query to work. I have a table of people (with ID's) and a table of languages (with People IDs and Language IDs). Now one person may speak many languages. I have put in the relationship....

My Access 97 applictions seem to have recently become very Cpu useage hungry. When opened they go to almost 100% useage on the peformance monitor. After several seconds this returns to near zero but again goes to near 100% if the access window is clicked though it has remained the active window throughout. Again subsiding after several...

Hi there, I wonder if anyone out there can help me. I'm setting up a database at the moment for a manufacturing company. In my database I have a table listing all the company products; I have a related table listing the subcomponents of each product. (The company makes both the sub components and finished products.) I have a third table...

This probably is not the best group to post this question but any ways. I've been working with ms access for the last couple of years and gotten very good at it. I have never been on any ms access course, all I know about ms access I have learned from you guys and other websites and books. I started creating very simple application and...

Thank you Alex, I have tried your suggestion to add requery in the afterUpdate Form's event, but it seems not work. The afterupdate event in my unbound combo box is : SetValue, GoToControl, Find Record, Requery Please comment! Thanks!

On the computer side of the businees there is me, the developer. Another person's role is that of the idea man...the person that knows the business and requirements and issues for the business. Together we put together an application we both think is of value. The app is written. Of course, the app is not finished. I suppose I could work...

I have looked for examples using " Double Columns per page but have found none. I have created a Query from a table, they consist of only 2 Fields namely Movie and Id What I am trying to achieve is having 4 columns per page or even six if possible. This will save on paper. Do I need to put a table in the report design??? Any help will be...

I have a table that tracks the entry of certain datapoints. tbl_data_entry: data_type_id (ties eventually to a department, formatting, etc.) employee_id date value Along with this I have a histoical logging table that is a copy of the previous table but also has the windows username and the date the value was modified (in case anyone...