Search results for query: *

You've both given me some direction. I've slept a couple of years since I built a database with continuous subforms -- so thanks for reminding me about the limitation on CF's combos. I've read online that a - perhaps not the only nor the best -- solution is to lay a textbox on top of the combo...

Am puzzled. I can't get an errorless sync between combo boxes on the same record. tblManufacturers has a 1-to-M relationship with tblModels. say, ABC Manufacturing has 3 models: red, blue, and green XYZ Manufacturing has 3 models: XYZ1, XYZ2, XYZ3 DD Manufacturing has 3 models: DD1...

Sort of answer my own question. Under Edit, right click a checkbox. Radio Button Properties 'form' will pop-up. Under General, the Name should be the same for each checkbox you want in the 'radio button group'. So, in my case, I have a Name for the Yes ckbox: undefined_10 and for the No...

I do little in Acrobat. I am mostly irritated by companies forwarding a non-fillable pdf to me for completion. SO, I convert it to a fillable form and send them a blank fillable and 'suggest' they use it in the future. Anyway, I have a fillable form I created from the Acrobat X wizard...

Will do. Good advice.

Excellent. Very helpful. I could have gotten there after a couple of hours but it would have been clunky at best. And I just ordered an Excel 2007 pivot table book: "Pivot Table Data Crunching for Microsoft Office Excel 2007" Jelen, Bill I respect your suggestion on use of PTs. As time...

What I am working on is essentially a pivot table. The data is in a flat file... Date Description Amount 8,000 rows +/- The Description strings in the raw data are searched for certain key words and the record is then classified as to category. Code then runs to group and sum all...

You're absolutely correct. "Say A2 is 7/1/2012, A3 is 7/2/2012, etc. -- out 2 years." would indicate rows, not columns. It should have been "...B2, C2, D2 have the dates " My mistake. Whereas you answer dozens, if not hundreds of these over a period of time, I ask only 1 question every few...

I use the filter a lot to hide/unhide rows of data based on criteria. However, I don't know how to filter columns. How would I use a filter to include the ranges A1:A4 (Labels) and C1:D4 (Data, with Dates in R1) based on dates? If filtering of Columns won't work, I think I can write the code...

I'm unclear if you are using Access or Excel as the source of the code. Are you trying to export from Access to Excel (using Access) or import into Excel from Access (using Excel)? And I'm not sure what is timing out. With some clarification, we can help you. swtrader -- If you don't know...

I have a range of data from A1 thru H731. Rows (except for R1) in Column A are labels. Columns in Row 1 are day-by-day dates. Say A2 is 7/1/2012, A3 is 7/2/2012, etc. -- out 2 years. At various times a user may want to print only 9/1/2012 thru 11/30/2012 or 8/1/2013 thru...

Great. Thanks. Here's what I needed: Dim OldTableName as string Dim NewTableName as string OldTableName = "tblFileName_BU2" NewTableName ="tblFileName_BU3" DoCmd.CopyObject ,NewTableName , acTable, OldTableName this keeps the old table and creates a new one

If I hardcode the table names, the code runs. However, I need to use varibles for table names. What is the proper syntax to be able to use variables? Thank you. Private Sub Command18_Click() Dim tblFileName_BU2 As String 'old table Dim tblFileName_BU3 As String 'new table newtable =...

Solved. I toyed with and wrote some clunky code but it works. Thanks for looking. swt

addy, Thanks for your help. It made me realize that I really didn't have a common ID between the two files -- which made it impossible to run an Update query. I bootstrapped getting the FileNo out of the FileNames file into the myFiles file(which has the files listed from the system folder)...

I am using Allen Browne's code to get file names. http://allenbrowne.com/ser-59alt.html / Thanks, Allen I would appreciate help in editing it so that the full path is in one field. Also, although I can probably figure it out eventually, it would be good if someone can write the code that will...

Am putting together a document management db. Briefly, certain info is selected from combo boxes on form (from table: FileNames) and a concatenated string is created getting something similar to this: ABC.SignedLease.DSmith.20110901.FileNo1 which will be saved as a pdf file, OR...

1921 static rows. Print area BD1:BQ1921 Autofilter is used on Column BD to hide unpopulated rows. In this example, BD1:BQ625 are populated and BD963:BQ1121 are populated. When printed, the report breaks at row 1024. I have tried various syntax to try to force a break at row 963 including the...

I am not the resident tech person in our little company. However, I built and maintain the Access database that we use. So -- I know a bit. BUT, I know nothing about HTML or ASP. Short question: I am trying to create a vcard that we can attach to our Outlook outgoing emails. I have used the...

Thanks, Skip -- This is what I finally scrapped together. Interestingly, I did not use Resize in this part. As is usually the case, I don't fully understand everything but I did get it to work... (The 'syntax' on the Range setting was part of what I had trouble with) With schrange...