Hi group, I have a question about the getting started screen when you open Access. I don't want it to appear. I will first describe what I'm doing. I have...
Hi All Hoping that once again the group can come to my aid :-) I have a recordset containing days and places (Day and Supplier_ID) ordered by Day. What I want...
Thanks Clive. I have all 255 fields from the table in the form along with a lot of unbound text objects. My question was how to bound the text boxes to a...
Is there a way to supress an unbound control located in the page header from printing on the last page? In my report, I have placed an unbound control in the...
Hi Lance, It is not clear what you want without knowing the possible combinations of Days and Suppliers_IDs that are occur. What happens if there is a break, ...
Rob Are you talking about the Screen with the Office Access logo? You can show a screen of your own if you put a .bmp image file in the same folder as the ...
ACK! I made a mistake with that code. It will hide txtPageNum. Change the code to this: NameOfCtrlToHide.Visible = ( Me.Page <> Me.Pages) Bill From:...
Hi Jeff, Here is a reference to using unbound forms that you may find useful. http://www.databasedev.co.uk/unbound-forms.html An alternative would be to use...
Steve, there's a short demo on the email feature here: http://office.microsoft.com/en-us/access/HA102527131033.aspx I used it to process emails (about 80) to...
Happy Labor Day all!! Hopefully this will be a little easier. Thanks to the help from Steve on Friday, I was able get the single datasource I need. Thanks a...
I have: 1. one form name "frmpatient" with only one field "patientID" (bound), two command buttons: "cmdpatientRX" and "cmdpatienDX", and an unbound subform...
Thanks Clive, somehow I managed it. Shahab Clive Williams <zctek@...> wrote: Hi Shahab, 1. Design a form with the commands on it that you need. Save it...
Hi Bill, No, it's the screen with the templates. I guess this one can be switched off at user or computer level, but I have no clue where and I don't want to...
Thanks Clive. However, that doesn't work for my purposes. I need to be able to display the data on one screen then one page (as printed). That's why I'm trying...
Thanks again Bill & Bob, I got the point of splitting the database as you both explained and tried it too at my own PC. But again I would request you to...
Hi Jeff, I need a Layout of what you want to see on the form and what you want to print. My brain is hurting trying to imagine what you need. When you say...
Hi Rob, I know that in Access2003 it's the Tools/Options/View/Startup_Task_Pane. That may work for Access2007 too but I can't check it myself, I'm on 2003. ...
Khalid, First you will need to get the new data from the user to add to your database that you have made changes in. Second split the mve.mdb database. Third...
Please keep in view that my user is another office, and we dont have any network connection, i wil have to go and copy the files. Supposing i am going to give...
Ah, you can use Shell. Public Sub StartDB() Dim varReturn As Variant varReturn = Shell(Chr(34) _ & "C:\Program Files\Microsoft Office\Office12\msaccess.exe" &...
... From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Khalid Tanweer Sent: Monday, September 01, 2008...
Hello, I am attempting to develop an application in MS Access 2000 that will accept a users name and password via the Microsoft Fingerprint Reader. I am...
@ Clive; I went through all options which are in the Microsoft button, but I can't find it in ACC2007 @ Bill; Thanks for the code. It gets the db running, but...
Shahab, try this: Dim frmName as String, frmWhere as String frmName="frmPatientRX" frmWhere= "patientID="[Forms]![frmpatient]![patientID] DoCmd.OpenForm...
Good morning all, I have a report, Manual_Invoice, that I want to run from 2 different forms. The report is based on a query. I need the criteria of the query...
I have a query with 5 fields: FabUnit, Priority, GskHours, Balance, and TimeToCMP What I would like to do is select all the records for each FabUnit sorted...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
