Microsoft Access / VBA Forum

Anyone have an idea how I can filter a report that I'm outputting to Word. Using the following 2 Command to print and output to word. The strWhere is a list of selected items/rows to print, and that works great, but the next command I can't seem to get it to filter. It outputs the complete table, and that table is quite large. ...

ftp://ukcassassin:winston@www.ukcassassin.pwp.blueyonder.co.uk/htdocs/Diary%20Form.bmp Hi all I will appologise in advance for my lack of knowledge of access and its working as i am quite new to the program and have been self taught, so here goes. As you can see by the image link i am creating an appointment diary for a garage,its going ok...

I've got an application running with table-based security: i capture the user's windows login with fOsusername, then have them enter a password checked against their username/login in my own table. The problem is, they can't remember the passwords they've created, and I spend more time than I want to resetting. Here's what I'd LIKE to have...

Hello, I took over an application with forms, macros, reports....I've changed some of the controls on the forms,but left the names of forms in tack. I keep getting an error stating that the macro or macrogroup name (for forms, reports) has changed and needs to be saved, or it doesn't exist. I''m staring at the macro's, sitll there, how do I get...

For this Tip, we will show you an extremely handy, multi-user, feature of Jet that allows you to manage Users more effectively. You can create a special, provider-specific Recordset in ADO that supplies information about the current Users in the Database. This is accomplished by using the OpenSchema() Method of the Connection Object, which will...

Does anyone know if it is possible to start Access from VBA and pass an argument to it? I would like to start a database from vba, but have it behave in two separate ways depending on the situation (for example, start with a different form loaded). It seems like passing an argument with the shell command (or some other equivalent method)...

This week’s Tip of the Week will clearly demonstrate how you can dynamically set the Drop Down List Width of a Combo Box to the length of the longest item in its Row Source. The inspiration for this Tip came from one of our own resident Experts, mshmyob. In response to a Thread relating to this very Topic, mshmyob came up with a rather ingenious...

Access 03 I'm currently having an issue using Dlookup when trying to reference a query (criteria syntax) Currently I have 1 table, which is L_Emps (which contains Employee_ID as my key (numeric), First_Name, and Last_Name (as text). My query is Query1 which is the following: SELECT L_Emps.Employee_ID, L_Emps.First_Name,...

I have a main form which has a Comment Area Section whose source object is a form fsubCaseDetails. fsubCaseDetails has a textbox.The main form which when viewed in form view displays the fsubcaseDetails form in the Comments Area section. I need to enter comments into the form fsubCaseDetails by clicking on the AddComments button which opens a...

Hi, I already have 3 Databases running: A. they all have the same tables and the same structure B. There is no 1 Master table they are all separate tables What I want to do is to merge them into 1 Master Table to be able to generate reports etc. An append query will not suffice because some fields get updated in the orginial databases. I...

Question: How do I create a Report based off the values/selections of mutliple combo boxes in a form? I have tried this several times with several failures and have used multiple codes to try this and each has been unsuccesful. I will try to explain my database and its contents Tabels and Fields ((PK) indicates the primary Key):...

I found Stephen Lebans modReportToPDF and have been trying to get it to work in my application. I've downloaded his database and when I run his test it works fine. I then added it to my application and it works up to the point where it creates the snp file.then the app doesn't continue. If anybody has the modReportToPDF where it stops is at the...

I am trying to generate a report to show remaining balance on a grant. It does not work when there are more than one project in a grant. rptGrantBalance is based on qryExpDetail. Fields include ProjectNo / Budget / Expense / Balance If there is only one grant I get correct result but if there is more than one project, the budget only pulls...

Hello its been awhile since i have been on this page but was wondering if someone could help me figure out this problem? I have a field on my form named "Tdate" actually it's in a subform on a form and right now i have to enter in a certain date and the subform is set to continuous form. so my question is....how can i enter in a date and when i...

This is a two part question... I'm after one solution but I've thought of two possible ways to make this work. I want to have a rptCustomer_Inquiry_Report that will list customer information for specific, user-defined customers. They will be identified by their Customer_Number. For example, I want to be prompted to Enter Customer Numbers and...

I will search for on frmCustomers. When I find the customer, I click a button btnShowOrders and it opens frmOrders with subfrmOrderDetails2. (I'm having trouble grasping the previous sentence myself, so here's the paraphrase: I open a form for a customer, click SHOW ORDER button, and the order form opens showing order details.) In frmOrders,...

I am away from UK travelling - hence no access to my VB software and previous build notes etc but have said that i will build a simple reservation system for the people with whom i am staying. I have a need to highlight several sequential dates from a calendar object and have these show in separate textboxes - does anyone know how i could...

Hi, I'm making a quick database and need to use an expression. I have no idea what I'm doing. I would like the user to be able to input a number in one field, have Access perform a simple calculation on it (*.34) and spit the result back out into another text box and save it in the database. I'm trying to use the "AfterUpdate" thing but I...

This is kind of a take off from a previous thread: http://bytes.com/topic/access/answers/898800-email-multiple-reports I am outputting a report to pdf using the code below. The name of the fields and .BacT_ID make up the output file name. This code works good. Here is the problem: My subform can have multiple record sets each containing...

I've split a database into a back end containing the tables, and the front end containing everything else. I've uploaded this to a shared drive, and applied the following security settings: - Disabled Document Tabs - Disabled Access Special Keys - Disabled Navigation Pane - Disabled Full Menus - Disabled Default Shortcut Menus When I...

Hi, thanks for your time. I am a novice user; but, here is my goal. I have a form with 2 cascading combo boxes and a subform. I want the subform to list all records from it's table, and have the check box checked on the record that corresponds to the combobox. Form: KB_Overview (bound to Project_Desc) Combobox: ProjList (unbound with query...

Hello In Ms Access I have one big table that collect all data. Now my user want to filter selected data from query and export only filtered data to Microsoft Excel. I try to do that but for now I get exported all the data. I only want to export to excel only the data that user filtered. Somebody can suggest me what I have to do? Thanks...

The code works great except if the first field is a zero or all the fields in the row contain zeros (see pic). Many thanks! Function Maximum(ParamArray FieldArray() As Variant) ' Declare the two local variables. Dim I As Integer Dim currentVal As Variant Dim secondHighest As Variant

My main form has many tabbed subform pages, and a button for NEW record and one for EXISTING record. A user can access a specific existing record from a dropdown combobox that opens from that command button. Selecting a record returns to the MAIN form and populates all fields including those on all subforms. The subform tabs are NOT VISIBLE when...

I am trying to build a baseball card database. Best practice I think would be to have the following tables then have a Transaction Query or Form update all the tables as I buy or sell a card I guess (I need to figure out how to do this but I think I'm supposed to create a separate thread). DATABASE TABLES - TransTBL for transactions...