Search results

It’s been a while since I've used Access (360), so I'm very rusty. Is it possible to have the autoonumber primary key start from 1000? If so, how? Cheers, Jake

Hi, It has been a few years since I used Access, so I'm asking your patience.. I am trying to open a columnar form from a tabular form (continuous) using a command button. I used the button wizard, but when I tried to match the key field ("id") in each form, it only showed fields on the right...

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...

Hi, I have a report that has three fields that could each have a the same customer name in, based on a query that asks for the customer name. If, for example, two of the fields show the selected customer, is it possible to hide the third field that has a different customer name in? If it...

Hi, In my Summary report, there are two groups: jobNo within Category. jobNo contains data which can be repetative, but not for all records. In other words, there can be: 6 records with jobNo 1234, 2 records with 4567 and 1 record for 9701. I want to count the number of times that jobNo...

I'm not sure if this is a syntax problem or not, but: I am trying to design a parameter query using a form for entery. The trick is that I am trying to use a wildcard in order to select the data for one of two job sets. My job number format looks like this...

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 tring to use a msgbox along with a validation rule for a calculated field which does not allow the user to progress until the data is corrected. There are three fields involved: TimeDateStart, TimeDateEnd and TotalTimeUsed. The formula is below: TimeDateEnd-TimeDateStart=...

Hello, I am having a bit of a problem trying to set up a message box. I have a date field and a time field as the last two fields on my form (continuous). I would like a message box to display if the time field (formatted "medium time") is left empty. It must be filled out to complete the...

Hi, I designed a form for other users and it has been running perfect, until last night. Within the code, I used the toolbar method to hide three toolbars, one of which is a menu replacement, along with two other toolbars that I use for maintenance issues. I have the code passworded so that it...

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...

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, plus an...

Hi, I am trying to create a general date field by combinging a date (short date) and time (medium time) field. The fields are named recDate and recTime for the two I am combining, and cmbDateTime for the result field. When I run the query, the result I receive is an errror stating that it...

Hi, I am trying to run a query that selects all records for the current date. In one version of Office, it would work well with the Date() function. But in my Access 2002 version, the Date function is reported to be non-existant. So, I tried the Now() function, but obviously that relates to the...

Hello, I have an access query that I would like to have the user prompted for a date range to list records in a tabular form. The "Between - And " query works fine, but trying to get it to prompt for the range is something that either I am not grasping, or it is not possible. Any and all...