Search results for query: *

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

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

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

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

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

I've copied and made a couple of clunky modifications to internet-sourced code to accomplish: 1. Opening each Excel Workbook in the Tracking Reports folder. 2. Getting a customer number and storing it in schrange (the customer number appears only in Cell E7. 3. Getting a 20 row by 2 column...

Dim S As String S = ActiveSheet.Name -- other code, going to different worksheet -- 'trying to return to S Sheets(S).Select -- doesn't work What does work? Thanks.

I have a report that has five columns. 4 of the columns contain minimal info (like a dollar amount). 1 of the columns, however, contains: CompanyName, IndName, IndTelcoNo. I want this to 'split' and be centered on 3 different text rows within the cell....such as ABC Co. John Alexander...

On a sub-sub form, I have a combobox. Double-click opens modal pop-up form listing all items that combobox lists. The pop-up form has an extra field, Archive?, for each record. The user can then select a record to archive -- thus 'hiding' it from view in the combobox. Once the modal form is...

Given: tblVols pkVolID VolFirstName VolLastName fkShiftGroupID etc. tblShifts pkShiftID ShiftName ShiftStartTime ShiftEndTime etc. tblShiftGroups pkShiftGroupID ShiftGroupName (ShiftGroupName = "MainGroup" will have all 10 shifts - (A thru J)) (A Vol might be able to...

I am working on an Access application that will assist (require?) compliance with a file naming convention. What I would like to be able to do is show the user a list box of all files he has open -- whether they be pdf, xls, doc, etc. User would be able to select a file and certain portions of...

I copied the following code from vbaexpress.com over a year ago. (Modified it slightly to fit my needs.) It's worked perfectly for over a year. It now fails on the line: Set mlItm = itm Possible reason(s)? Thank you. =========================================================== 'Created by...

The following code is copied from the web and attributed to: FMS Development Team -- and it works great for what I am trying to accomplish...using Access to rename and move files...with one exception... It deletes the 'old' file once it has renamed and moved it. I need to leave the old file in...

A11 = "ProjectedCash" (the name of a different worksheet than the active one - which is CashFlow) CashFlow is the name of the worksheet where the following is in cell F17. This formula correctly pulls the value of F17 from ProjectedCash wksht. =INDIRECT(""&$A$11&"!"&"F17") However, I can't...

I will have 1 spreadsheet for actual cash and 1 for projected cash for each month going forward. (The actual will pull data from a list of actual cash transactions through "yesterday"; data will be pulled from the projection spreadsheet (into the actual cash spreadsheet) for "today" and all...

Here's a portion of my code that I need to loop. Whether I put the "Loop" before or after the "End If", I get the error, "Loop without Do". Do While rTC > 1 If InStr(StringToSearch, SearchTerm) > 0 Then 'put the Code in the cell to the left of the transaction detail MsgBox...

I am using Access as a Document Manager -- saving most (but not ALL) documents in one folder. I drag the document into a hyperlink text field on a form. I would like to extract the name of the file to an adjacent unbound field. Given these possibilities...