Search results

Hello Access Programmers, I have a new field I've recently added to a subform that I want to be required before tabbing to the next available field. How can I control the user's action to disallow 'tabbing' over this required field? (ie, if they try, they get an err message pop up saying...

Hello, I am having a heck of a time getting a Dell laptop with a WIRED connection to connect to an Access 2007 database. After foolishly connecting to this database wirelessly, I took the wise advice of members here to never connect an Access database using a wireless connection due to Access'...

Hello Access Architects! I am in the process of creating a small-scale database (suitable in Access) that tracks my client's music collection. This is not a CD collection but rather a sheet music collection for a community choir with 20 - 25 singers. To make things really simple, I will have a...

Hello, Can anyone suggest a possible solution for the following problem? I have a simple popup form that has a checklist of events the my company wants to keep track of. Basically, I have 5 check boxes. Next to each of these check boxes I have a date column. ie checkbox1 represents (Did client...

Hello, I found a somewhat related thread but thought I would post a new one just in case my problem happens to others who were 'forced' to "upgrade" to Windows Vista Home Basic when buying a new machine.... Okay, no more complaining, here's the issue: I have a small (8 MB) Access 2007...

Hello, I am having issues opening the calculator... I have a control on a form that opens an excel spreadsheet (and even dumps relevant data into specific fields in Excel!) and yet, alas, I can't seem to figure out how to open the calculator! I've found the path to be...

Hello, I am trying to configure an easy way for my clients to access attachments in an Access 2007 database. The idea is that they can attach XLS, DOC, and JPEG files all to a record in a database. I saw that this is a relatively new feature in Access and thought I'd give it a shot. The only...

Hello, Can someone help me with a formula to do the following: I'd like to have cell A1 to be a start date. A2:A9 will equal A1 Date adding a week respectively. so if A1 = 1/1/2007 then A2 = 1/8/2007, A3 = 1/15/2007, A4 = 1/23/2007 etc. Thank you for your time! Mike :)

Hello! I have never done this before but don't think it would be too hard to set up. I am working for a construction company at the moment and would like to have a type of image gallery function for the client info form (I called it frmClientInfo). Basically, when a supervisor takes a...

Hello, I think this is possible with a crafty use of me.allowedits = false but I'm not sure. I have a form that has two subforms in it. I simply want to make this form (and the two sub forms!) LOCKED so the user has to click a command button to unlock them. It's not an issue of security...

Hello Excelers, I'm not too familiar with Excel formulas so I apologize if this is a very mundane and simple question. Can anyone help me do the following? I would like to have a column calculate a total if the column before it is above 40. For example, this is a simple spreadsheet to...

Hello, Can someone give me a hand with a file path to a computer on a basic network shared folder? This is what I have so far: Private Sub cmdGenCheckList_Click() Dim objXLApp As Object Dim objXLBook As Object Set objXLApp = CreateObject("Excel.Application") Set objXLBook...

Hello, Quick question: Can someone suggest a bit of code that will show the 2nd column from a combo box in a report rather than the first? I have used the following code in a form, but it doesn't work the same in a report... Me.MyReportControl_detail = Me!MyReportControl.Column(1) Basically...

Hello, I think this might be a typical question for query builders, so I apologize in advance for asking something so basic. I have a form with two controls (start_date) and (finish_date). Is there a way that I can create a query that will count the number of times a "source" has been...

Hello Access Forum 'Form'ers, I have question regarding a simple way to retrieve information in a report (based on a query). I would like to create a Form (called frmSelectDateRange) where a user can retrieve results from a query (and consequently shown in a report) using combo boxes. I think...

Hi VB coders, I have a bit of code that opens an Excel template file from an Access form: Private Sub OpenExcelFile_Click() Dim objXLApp As Object Dim objXLBook As Object Set objXLApp = CreateObject("Excel.Application") Set objXLBook =...

Dear Excel Gurus, I'm partially embarrassed to ask such a basic question, but I need help with checkboxes. How do you create a checkbox in Excel 2007? Microsoft has changed the formatting menus so much, I am totally lost. It's not the way it used to be "view | toolbars --> forms" in previous...

I have an issue with the format of the data in a form. I have a form I'm using to calculate totals (in the currency format). If the difference is negative, the negative result in the control is displayed with brackets instead of something like "-$20,000" For example: me.control3 (the text box...

Hello, I am looking for a way to populate a field in a form based on a combo box result entered immediately before. (dependent/independent combo box setup) This is what I have right now... Two tables: FullName Wages --------- ------- FullNameID FullNameID...