Hello all, I have a standard module which contains the following Public MySELLERID As Long Public MySELLERNAME As String How can a reference the...

I have form based on a table. The table is appended daily with new records. The goal of the form is to provide a place where people can view the new...

²âÊÔ¿´¿´×Ô¼º·¢ËÍÓʼþºó¶à¾ÃÄÜÔÚÐÂÎÅ×éÉÏ¿´µ½

Hello all, I have an update query that works fine in my Development database that I use to run ad hoc requests or tinker around with new stuff. The same query...

;I have a small dB that when on my personal drive at work works great and opens quickly. then I had to move it to the Network drive and every time we open it...

I've created a crosstab from a table with data laid out like this: Group Section Title A One John - Manager A One Joe - Analyst A Two Jane -...

I have built an AC2003 database. I built color schemes matching the olive, blue and sliver colors used by Windows XP. I found the constants that I can...

I realize I am not in the right section for this question, but maybe someone can point me in the right direction. My profile on this group discussion area...

How to disable the right click of the mouse on an open form and report ? Or for that matter in all of my application. Thank you once again. -- Eric

I have an AC2003 database that has a textbox with a backcolor. I need to dynamically change the backcolor value to a lighter shade of the textboxes current...

Hi, Some of the fields I have in a table which is imported from a csv file a Salesperson (has up to 20 names in it) Status (has...

Hi, I have an access report pulling information from a query. One of the fields is “PHD� and it has values “yes�, “No� & “N/A�. I understand...

Is there a way to add criteria to the expression that creates my serial numbers? Me! = Format(DMax("", "") + 1, "0000") I want the next number in the series...

Hi, I am trying to achieve changing the captions of a textbox in a continuous form. I achieved this using code (and with the help of knowledgable people on...

Hi there, i have a form where i would like to use for search by two criterias: Lot# or Part Number - these are two field in the table. need help to add that...

I have developed an Access 2007 database (split into fe/be) and have access set to shared and no locks. When I place the BE on the server and try to connect...

I can't seem to get the right combination with an input mask that has a default area code but lets the user change it if necessary. Any help would be...

i have text fields on my database, when i type in text it can be sometimes very slow until it apears on the screen Any idea what could be casuing this

I have a form with sub form on it I use this form to search for products we keep in stock with prices, I have a Search text box on the form then i type in the...

Hi, i defined following procedure in 'module1' (Access 2007): Public Sub maproc() Shell "Notepad.exe" End Sub Now i want to start it from a macro. in column...