Search results

Strange situation I have solved but don't know why I had the problem. Just want clarification so I don't have this happen again in the future. Using Access 2007. I have a table "StoreInfo" that stores the store number, store address, etc as text fields. I then have created a query...

We are trying to decide between reworking our FE/BE Access 2002/2003 database in Access 2010 or SQL backend and Access front end. My prior experiences with Access 2002 was when the database bloated to about 100mb, it started having problems corrupting records and became unstable. I spoke with...

This seems to be a common question but I can't get it to work with any of the suggestions I have seen. Here is my problem. My row source is a query bound to the ID in column 1. I want the Client Name in column 2. In the red highlighted portion of the code, if I leave the .column(2) off, my...

I have a query I want exported to Excel. I then want to format the Excel file for column width, font, font size, bolding, etc. I created the macro in Access 2007 to export the query and then open in Excel. I then converted the macro to VBA. No problems there. Tested and everything is...

I am having a small problem with null. I have a form that allows me to add questions to each selected record if I would like to. Not every record will have questions related to it. I am also showing in a text box the count of questions for each record. Everything is working just fine except...

I have a form (frmMyTasks). I have two subforms on the form (tvMyTasks and sfrmMyTasks). These are always visible and there are no problems. I have a third subform (QSubform) which is made visible by a button on the form (frmMyTasks). No problems there. I have a button on the subform...

I want to export an Access 2007 formatted report to Excel, keeping the formatting. As I read a little, that is not easily possible. Also after reading, I will be using automation. No problem. Seems easy since I haven't yet started to write any code. My report is grouped and the grouping is...

Can I open the recordset using an IF statement? For example, if radio button #1 is selected use Set rst = CurrentDb.OpenRecordset("qryMyTasksCurrUser") else use Set rst = CurrentDb.OpenRecordset("qryMyTasksAllUsers"). If yes, to the above question, how do I reference the option group and...

I am setting up treeview on a form which has not given me any problems. I made one small change and now I am having issues. All I am doing is using an option group with just two options (current user and all users). Current user has an option value of 1 and all users has an option value of 2...

I have a small problem I am not sure how to correct. I am running the following code from a button in frmSearch. It is all working with a few small quirks. The button does a quick check to make sure only one record is selected. If only one record is selected, it runs the code in red below...

I need help. I have never dealt with a LOOP before so I am completely in the dark. I searched the forum but am still unclear. Let me summarize what I am doing and what I want to do. On frmMainMenu I use a tab control that has a search on one of the tabs. The user enters multiple criteria...

I am testing portions of my app and found an unexpected problem. I have code in the change events among others. If I make all my selections using the mouse, all my events fire as expected. If I tab through and make my selection using the keyboard, then tab out to the next combo box, the...

I have a tab control in a form with two pages. Page one is the main menu and page two is a search form. When I switch to the search page, I want to run some code to clear any selections from previous searches. I know how to clear the selections with Me.cboName = Null. I tried to enter the...

tblYear has two fields, YrID as autonumber and YrEnd as date type. tblTaskDetails has a field TaskDate as a date type also. I have a search form with a combo box cboSrchYear which is bound to tblYear. My user selects a year (I used the Year function so that only the year shows in the combo...

I have a question regarding clearing the contents of a text box. I know all I need to do is Me.OrderDate = Null or Me.OrderDate = "" Is there a difference between the two? For example, in Excel I can "clear" a cell by pressing the spacebar but the cell is not really empty, it just has a...

I am creating a workflow database for my office. We currently have a good program but it has minimal flexibility for customizing for our office. One thing it does well is search for records based on multiple criteria. Once the list of records is shown, I would like to select individual...

I have a login form which remains open but not visible after successful login. On that form I have a hidden text box "txtSecLevel" which indicates the security level of the employee signing in. I have a main menu form "frmMainMenu", with buttons to open the forms, which runs an IF statement...

I have a combo box bound to an ID# and then there is a 2nd column with a description. I have a dlookup that I would like to have the description sent back to me instead of the ID# in my text box. The statement is below: If Me.cboCategory.Value = 2 Then Me.txtDatePerClientInfo =...

Where is my problem? I have been trying to solve this for about an hour now to no avail. If Me.cboCategory.Value = 2 Then DLookup("ClientYrEndMo","tblClientInfo", "[ClientNum]="& me.cboAcctNumber) If the value in the combo box selection is 2, I want to determine the year end month from...

I have a login form where a UserID and Password is entered. When the user creates a new record, I want to add the UserID to the record. I have a form, bound to a table, where the user enters info for a new record. How do I capture the UserID and add to the record?