Search results for query: *

Hi, I have several forms that have the same option group on them that do the same thing. I want to create a public function so I would not have to have all the code listed below on all the forms. There are 5 options and if you click one the others would go back to there default settings. The...

Hi all, Is it possiable to reference a subforms subform field? ie. forms!frmBIGONE!subfrmNextBigOne!subfrmLastBigOne.form!anyfieldname frmbigone is the main form. subfrmnextbigone is in the main form. subfrmlastbigone is in subfrmnextbigone. anyfieldname is the field i need to reference. Thanks

I am trying to run an update query and i get the following error: The parameter values are too large. The total length of all the values entered for the parameters cannot exceed 1,024 characters. The field is a memo field and it is just updating the other related records memo field also. if i...

I am trying to get the code below to order by nsn but when i add the code i get an error: 'excute a query that does not include the specified expression 'NSN' as part of an aggregate function.' Set rsHR = Cdb.OpenRecordset("Select Count([HRID])as HR from qryrptflighthr WHERE PID = '" & Me!PID...

I need to fill out a report with blank records that will fill up the last page of the report down to the page footer. Also, the first page of the report will have a 5 line page footer. all the other pages will have a 1 line footer. I can get the 5 line page footer to show on page 1 only and the...

Hi, Need a little help. I need a number field, can't be an autonumber. That will number consectively, alphabetically from A to Z. (andrews = 1, buns = 2, chan= 3 and so on). now if i delete buns(2) I need to requery the table and now andrews =1 and chan=2. If i have 20 names and then add...

How do you loop through a query? I have a report that can take 12 records per page. so the first 12 get a level of 0. then the next 12 get a level of 1 and so on. if i delete one of the 12 in a given level (it may be in the level 0 or another level) and there is another level behind it (ie...

I need to make a report that has names across the top and book #'s down the side. There will be no data under the columns it is made to print off and then will be filled out by hand when the person reads the book. I have a table that lists the books and will go down the left. and if there are...

Is there a way to code an event that would bring access to the front(make it the current window). If i am running different programs and access is in the background, I want access to come to the front when an event happens. Thanks,

Hi, Did a search but couldn't find the answer. I have a combo box that has a recordset from a table that has over 80,000 records. Of course not all records can be listed in the dropdown. So I was going to break the combo box into two combo boxes. The first box will contain the text and the...

I have a dos based program that I export data from in text files. I can't change any of the export criteria so I have to make 2 files instead of one. One file contains all the publication info. However the export field sizes for pubnum and pubtitle are not big enough to show the complete...

Hi, I made a db in access 2000 and when run in access 2002 i get an extra message box that says 'you canceled the previous operation'. I don't have that coded anywhere, 2002 is adding it, and I don't want it. I belevie it is the docmd.cancelevent that is causing it. Here is the code for the...

I am trying to see if a file exsist before I import it into my db. If the file is not there and I run the transfertext command I get an error on the import. I would like to check for the file before importing. thanks

I am using the following code in a query to convert a text date to date field. PUBDATECONVERT: CDate(Left([FIXPUBDATE],2) & "-" & Mid([FIXPUBDATE],3,3) & "-" & Mid([FIXPUBDATE],6,2)) However on dates that are the 31st date in the month i get an error. ie. 31sep65, and 31jun87 both of these...

Hi, I am trying to do the following in a report. publication | name1 | name2 | name3 | (this continues on) a1 a2 a3 e4 r5 e5 e43 The publications are in one table and the names are in another. Couldn't get a cross tab to work, The publication or name may fill more than one page also. I don't...

On my form I can delete a record with a button. If I delete the last record of the table (I know this because I just added it to the table) the fields all go blank and when I try to go to another record I get the index or primary key can't be blank. Thanks