Search results for query: *

Bear with me on this. I am having a brain freeze and can't move forward with this one. I have a table something like this: IDField SaleDate CustomerID 1 1/1/08 552 2 4/3/07 552 3 12/1/07 552 4 4/3/08 444 5 6/3/07...

I have a suggestion. If you create a parameter to have the user enter the label number, go to the section expert for the detals and click on the formula for "Next Page after" and add something like this Remainder (RecordNumber,cdbl({?001_ROT_LabelNum})) <> 0 As long as you don't use multiple...

Thank you both! You were both correct. After working on this project for so long I was getting tunnel vision. You were both VERY helpful! Regards, Karen

I have tried several times in several ways to use an Insert Into Statement which includes a CASE WHEN in a select statement to insert into the table. I have gotten errors that there weren't the same number of fields in the select as the insert. I tried altering it and can't seem to get it...

Bob: If you are using that exact code you should look at the second "Set" statement. It should read: Set rst1 = db.OpenRecordset(strSQL)

PHV YOU ARE FANTASTIC!!! Thanks a bunch!!!! Karen L. Pereira "Great spirits often meet violent opposition with mediocre minds" - Albert Einstein

Thanks anyway guys, but the active spreadsheet is always the same. The code won't change the active sheet to the next one. I must have some problem with the install or some reference. I appreciate your help...this is a great forum!! Karen L. Pereira "Great spirits often meet violent...

HELP!!!! My frustration level is rising. I have tried to import all of the worksheets into a table in Access, but for some reason when I change active sheets, it doesn't change...I have traced the value of the active sheet ,but it isn't changing. I have tied iterating through all...

Thanks a bunch! [medal] Great logic! This is a fantastic forum! Karen "Great spirits often meet violent opposition with mediocre minds" - Albert Einstein

Hello: I loved the following article, but I need to do something different and I'm new to SQL programming. http://tek-tips.com/viewthread.cfm?SQID=859372&SPID=183&newpid=183&page=1 I am trying to take the items in the temp table and instead of sequencing them consecutively I would like to...

You might want to check to see if your form needs to be resized. If a form is sized too small for the entire tab control it will cut off parts of it...this often means the tabs disappearing. K. Pereira [ponytails2]

Can anyone give me some idea of how to fill a list box with the captions and names of all reports. I want to use this listbox as a selection of reports for printing. Any help would be appreciated!!!! Karen

I would simply setfocus on the field in that record you wish to be in. For example, DoCmd.GoToRecord , , acNewRec Me.EmployerName.SetFocus This brings the focus in the new record to the EmployerName field. I hope that helps. Karen

Can anyone tell me how to enumerate through all of the files in a directory and rename them. For example I have a directory with files such as 1.bmp, 10.bmp, 200.bmp. I want to rename the file respectively, DMS1.bmp, DMS10.bmp, DMS200.bmp. I haven't worked much with file objects. Any help...

Hello Everyone! I was hoping that someone might have the answer to a question. I have a search form with a listbox, a text field, a combo box and a button. Usage: 1. Select a value in the combo box, e.g. First Name, Last Name, ID. 2. Next, there is a text box to enter the search...

Do as Paul says. Let us say that you want the report to break on department. Create a department grouping and use both header and footer. Click on the footer and in the properties click on the format tab. In the force new page property select, &quot;After Section&quot;. This will force...

If you are using code to run the query you can use: docmd.setwarnings (True) This will turn off Access warnings while the query runs if it is placed before the query is run. K. Pereira

Try dSum DSum(expr, domain[, criteria]) expr -- An expression that identifies the numeric field whose values you want to total. It can be a string expression identifying a field in a table or query, or it can be an expression that performs a calculation on data in that field. In expr, you...

Thanks so much.&nbsp;&nbsp;This forum is fantastic.&nbsp;&nbsp;Help is nearly immediate!<br><br>Karen

Hi Everyone:<br><br>I hope someone can help.&nbsp;&nbsp;I have built a form based on a view which combines a few tables and a query.&nbsp;&nbsp;Maybe I'm thinking too much like Access.&nbsp;&nbsp;&nbsp;I have a query which determines the &quot;Last&quot; year (i.e. 99-00) in a...