Scenario:
Work orders arrive and pertinent data is put into an Excel spreadsheet. Each time a work order is received and receiving individual must create a work order number in the format "YYMMDD-" number of work order for the day (e.g., 01, 02, etc.). The spreadsheet thing drives me crazy...
i haven't posted before, largely because i haven't had a real need for much VBScripting. Now i'm in a quandry and would like some assistance. Windows 7 install has grown to 2 DVDs. DVD 1 contains Win7 + Office 2010, DVD 2 contains drivers for various models of computers. All of this will...
i know i've seen this someplace but i can't seem to find it now that i need it.
How can i create a dynamic combobox composed of the UNIQUE data in a field? For example: Field contains text data in the form of "0015" to "0095". There are 15 records with "0015", 25 records with "0035", and 3...
i have a form with two separate drop down boxes i use to find items in a table. One drop down finds based on an arbitrarily assigned number the other finds by item serial number. i got to thinking that i could use one drop box to search either field, in sequence (i.e.: arbitrary number, then...
i have a form with (currently) 2 tabs on it. What i want to do is when users click on either tab focus is changed from the form within the tab to a control on the main form. So far i've tried:
Private Sub pg01_Click()
' Forms!frmPersinfo!txtFindMe.SetFocus
' Me.txtFindMe.SetFocus...
Have a form with tabs tying several tables together. On the tabs are subforms. i'm having trouble with 2 that are continuous subforms. These subforms list different training data and have a "Delete" button next to each item. The "Delete" buttons work as advertised when designing the form or...
i haven't seen this in the forum yet so here goes...
i don't like the way Access deletes records on the fly. i'd rather they just be marked and then removed when the user decides they're not useful anymore. Form opens with a table, one field of which is a marker "Deleted." i'd like to code a...
i'm using Excel 2007 and have discovered the COUNTIFS() function that suits my needs nearly perfectly.
My problem is in getting the data i want from a sheet within the workbook.
Data sheet consists of 7 columns; Column 1 is a data, Column 3 is a number, Column 5 is a number, Column 6 and 7 are...
i've run into this before but can't remember the answer. Using Access 2003 a field has a value referenced in a lookup table however the text isn't showing, just the reference number. It should show a combobox with a dropdown arrow to allow me to select text and store the associated number in...
i have an existing, official "gumint" form that i would like to fill out from an Access database. It has all the usual government form fields (LastName, FirstName, etc.). i tried substituting "Adobe" for "Word".application thinking that the essentials are the same, it just needs redirected to...
i've been messing with this for a couple of weeks and can't seem to get it right.
Scenario: Form to get user data. Some information is collected and stored, some data is output to a (15 page!) form and the information is thrown away and not stored. The form is a Word document and i can get...
i've got a training show to run and the only i can think of is through a batch file calling 2 separate .VBS files. It appears to run fine ONLY if i pause the batch file.
Batch File looks like this:
ECHO OFF
Driving1.vbs
Pause
x:
Pause
Start.html
Pause
J:
cd \(original folder goes here)...
i don't mess with Excel too much so i'm having an issue with a simple IF() OR statement.
SCENARIO: 4 tanks daily dump chlorine into a water system. Any one or all 4 may dump at any one time. New tank weight is 150. Readings on tank weight are taken daily.
Currently formula is...
First time i've needed VBS. Got the mapping just don't know how to change to mapped drive and start required executable file.
i looked in Forum and FAQs and didn't find what i needed/wanted (though i DID find a few other things that'll help in other ways).
Thanks,
Dave
i've tried searching on this, but i can't seem to find anything close enough.
Table contains IndvName, IATestDate, OfcSym. Individuals must undergo annual training to remain proficient. i want to track this on a monthly basis. Current i can get Year trained and month trained, but can't find...
i've searched all over for this with no real results yet. i'm trying to build a dynamic table from a single dropdown box. The dropdown has well over 200 <option>s and there are well over 200 matching <option>s to display, some consisting of a single line and some with 5-6 lines. Right now i...
i have a main form that has a mark for delete button on it. (i've taken to just "marking" records for deletion instead of just deleting them outright.) Prior to marking for deletion i have a popup form come up asking to print the record. It's a simple "yes/no" form. "No" i've got, "yes" is...
i've searched the FAQs and read several of the posts in the forum and still come up with a blank for my question.
i have a one field form...
On the form i have two labels to show users they are either editing or adding records.
OnCurrent:
Me.AllowAdditions = False
Me.AllowEdits = False...
i have a small database with 3 date fields. If any of the date fields are changed i want another date field (Updated) to reflect the date the change took place. i've tried placing code to update the Updated field on each date field's OnChange() property. Doesn't work (that i can see). Any...
i know i've seen this before but i just can't find it.
i have a form; Name, Shop, 3 training dates and 3 calculated fields to show when training is next due (annually). In the BeforeUpdate property i stick the following code:
[code]
Me.Updated = Now()
[\endcode]
If the data in the form is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.