Search results for query: *

Hi, I designed a slide show that works perfectly in IE7, but I get a blank screen for the HTML page in FF. Can any one give me a clue what I am missing? The url is below. Thanks in advance, Jake

Hi, I am a bit confused where I went wrong.... In a form, I have 4 option buttons in a frame, named optLog. The Click Event is as follows: Private Sub optLog_Click() selLog End Sub In the module, the function selLog contains the following: Select Case optLog Case 1...

Hi, I have two tables: tblJan, tblFeb I have 1 form: frmMonth. I am trying to use a command button to change the recordsource to view another month. Here is what I have: Sub cmdFeb_Click() Forms!frmMonth.RecordSource = "tblFeb" End Sub An error message appears as follows: "Run-time error...

Hi, I have a report that has a grouping by a field called "JobNo". Sometimes there is one record (3 lines/record), sometimes there are three records. Is there a way to send a form feed so that the report is not able to print half of a record on one page and half on the other? Thanks in...

Hi, I am designing a report based on a query using BETWEEN in reference to dates. The question is, how do i get the date range to be printed on the report? Thanks in advance, Jake

Hi, My database includes a JobNo field that is masked to appear as "06-01-0234". I am trying to set up a parameter query that allows me to just search for the last four numbers. I am using LIKE [Find] & "*" then enter "0234", it does not pull up the record. If I use the entire...

Hi, I am trying to create a query that will show data in a rolling four month period. Example: For September, show June through September; for October, show July through October. I am using a general date format in the field. I can use >DATE() - 120 to get a 120 day period, but that...

Since any user is able to hold the Shift Key then double-click an Access file to open to the object panel and/or code, is there any way to prevent this other than a file password or using Access Security? I can password the code, but the object panel still is available. Thanks in advance, Jake

Hello, I have two fields (call them field 1 and field 2), which are both formatted for "General Date". Since they are used in a calculation of Date and time, I need both segments to be entered. Is there a way I can create a validation rule that doesn't allow data unless it is mm/dd hh:mm...

Hi, I have a combobox with three columns, and the bound column is column 1. With the following code, I have tried to make column 3 visible in a text box: Private Sub jobName_AfterUpdate() txtJobDesc.Value = JobName.Column(1) End Sub However, this is not working. Any help will be...

Hi, I have a custom toolbar that I want hidden on a form that is not connected to a database; it is serving as a "Splash Screen." Here is the Code: Private Sub Form_Load() DoCmd.ShowToolbar "myToolbar", acToolbarNo End Sub When the form opens, it shows briefly, then closes...

Hello, I am trying to write code to a module, but the module will not perform, I believe, because the form I am referrign to is not listed in the Microsoft Access Class Objects List. It is a valid form, in a single record format. The form works fine, but is just not listed. Is there any way...

The previously written thread of "Maximize Problem" was inaccurate. The problem is that my "Exit" button and all other buttons using vb code are no longer working. Nothing was done to the code or the buttons and they all seem to be coded accurately, and they have been working over time - until...

Hi, I have in the Form_Load() event, the following command: Private Sub Form_Load() DoCmd.Maximize End Sub It has been fine for several weeks, and today, when I open the form, it does not maximize. Also, there are a few other commands that are not working, connected to macros. I checked...

Hello, Is is it possible to lock a field in a form for a specific record after data is entered, without locking the field for all of the records? What I am trying to do is not allow any changes to the data in that field, once the data is entered. But if there is no data in the field, I want...

Hi, The field I want to filter is a text field, which accesses a lookup table of 47 records, each with up to 20 characters, many similar in spelling. In other words, the first six or 7 characters can be exactly the same. I am asking if it is possible to create a popup form with a single...

Hi, SQL is a bit new for me, so patience is appreciated. I am trying to create a paramater query that searches eight fields for the same value. I want to do this by entering the data value just once, so the MS Query grid will not apply. I have surmised that I need to create a variable from...