Hello-
I'm new here. I think this is the right place to ask.
I'm on Win98 using Office 2000.
I have a database that I use to run a PERL script for the record store I work at.
The database spits out a text & tabs document via a query that I then run PERL on.
My database has these fields:
date added
e-mail address (Primary Key)
name
wants
destination
In my form to enter, I use keywords that correspond to catagories in my website (I sell music, records & CDs) and also exact terms for if a customer is looking for specific items.
an example would be:
20060308
tim@couch-fort.com
Tim
*clrock~~*clrockcomp~~beach boys~~bob dylan
1
The "~~" is a separater for the PERL job.
Is there a way I can put checkboxes on my form that will auto fill data that repeats often, while leaving space for some hand typed info too?
I have a combo box for rooms: single, twin, double, suite, grand suite
This is found from a lookup table
In the next field on the lookup table is the cost per night for the room, how can i get the cost per night to automatically appear in a text box when the type of room is selected?
I use a form that has a combo box and a text box.The combo box values are Email,Cna,Dna.I manage to make users to select values from combo box and show it in the text box.I want to ask if it is possible when user select "Cna" and "Dna" from the combo box the same will appear to text box but the text box will be locked.If you choose email it would be enable.
I have a form for recording site details and have been trying to autofill three of the four categories.
What I have is a Site Index Table that contains the site ID, Name, Description and Type. I want the results to be recorded in an Affect Table that will also contain text data associated with these fields that I will enter in manually.
I then have a form with the four fields; the site ID and Type are both bound to the Affect Table that records all the data associated with each site. The Name and Descritpion source their information from a seperate query of the Site Index Table.
So what I want to do is to select the site ID on the form from a combo box I've created, and once selected it will automatically fill in the relevant text data into the Name, description and type categories on the form. I've been trying scripts with the DLookup function but have continued to encounter errors. If anyone can help PLEASE help me as i'm a novice when it comes to Access
Is there anyway or code to autofill a bound text/combo box for instance with the person who is working the database i have this code but doesnt work with bound boxes
:confused: I have a combo box on a form that is used for data entry that allows the user to pick the date. This is based on a table that includes date, week ending date and month, all very specific for our business. I used a function that says Me.txtBox=ComboBox.Column1 for example. So my combo box would include all the information, and all but the actual date is not visible. I want this to feed into another table that will be used for reporting, and that table has the same fields of date, week ending date and month. I keep getting an error saying that the value selected from the combo box doesn't fit the criteria, and I believe what is going on is that it is taking all the fields instead of just the date. Any suggestions how I can still have the text boxes update if I only have the date in the combo box?:confused:
Autofill text field using combo box selectionHello,
I'm trying to autofill a field on a form using MS-Access 2010 Web version sharepoint using macros without coding.
The form has an existing Combo Box field called Segment, using the row sources "REW", "WTT", "DBM".
A user begins filling out the form and eventually selects the Combo Box for Segment and selects any one of the segment no Multiple selection
There is another text field, which is actually alpha-numeric, called Job_No. I want this to autofill based on their Segment selection, using this format:
REW-YYMMDD-TTTT, or REW-131210-20001 for example, for today with the time displayed as military time and last Job No.(20001) for REW and Also for WTT (30001) as starting number.
I'm having a hard time with this (what I thought) was a simple filter. I have an unbound checkbox (chkFlag) and an unbound text box (txtfilter). The filter was working fine till I decided to also try to filter on the checkbox.
I'm trying to filter records that either have either a check in the [Flag] field or have some part of the text in various other fields. The problem is I can get the records to filter if the checkbox is checked or on text in the various fields, but not both. I've tried using AND and OR, but it's not working.
I have a form with three items:a checkbox called "Check231", a textbox called "text921" and another textbox called "text762".
What I wish to do is: Enter text in textbox921, which stays the same as I scroll through each record. Then If checkbox check231 is checked, it displays text from textbox921 to textbox762. Textbox762 is bounded to the form.
I'm looking to create a "Same As Billing Address" check box that would automatically udpate the address in an order to reflect the customer's billing address.
I understand how to sync a combo box to an option group ( -- great article by the way)
I Guess what I'm looking to do is:
1. Sync a "Same As" Checkbox to multiple text boxes in the form (Unit, StreetAddress, City, Province, Postal) such that these fields are UPDATED (writen to) with the same information as the billing address
2. [U]IF the "Same As" Option is selected, I need the updated fields to lock, allowing no further update... but must by unlocked if the "Same As" option is NOT selected.
Please help me out with this one guys.. I really need it.
I have a column in a table that only is allowed one value, "Repealed" or simply left blank. I would like to have a checkbox on a form that enters the word "Repealed" or removes it depending on whether it's checked or not, rather than having the user enter the word "Repealed" each time.
Can anyone offer direction as to how to complete this? I've not had much experience with VB code.
I would like to be able to use a checkbox control to make either text boxes or forms appear when ticked, ultimately to stop a form being so untidy/to conserve space. I'd be using this on multiple occasions.
(If actioned, would it automatically shift the other controls in the form down to make space, or would it just overlap?
I have 2 tables both linked to SQL Server 1 has policy information and the other has error information both tables are linked with the relationship policy Ref. The error table(table2) has fields Pol ref, Error_Type,error, Comments, response_comments and response_Date.
There are 25 types of error so what I have done is copy all fields from table 2 25 times exlcuding the policy ref and Error_Type but to make them relate to the relevent error I need to setup some VBA code that does an if Error1_checkbox is ticked then make Error_Type ="error1" and Error=1 else if error1_checkbox is unticked then make error_type null(blank).
I have the following code which works perfectly BUT I want to be able to add another line of text if users enable a checkbox. I have tried everything I can think of but can't get it to work. When using an "IF check150" statement it just adds the extra text in regardless of selection or not.
Code:
Function Mail_Radio_Outlook6(activedoc As String) Dim OutApp As Object Dim OutMail As Object Dim strbody As String Dim acc_req As String Set OutApp = CreateObject("Outlook.Application")
[Code] ....
This is fine most of the time but If a user ticks check150 I want to add another paragraph.
Do I use an IF statement, if so in what format? is it a separate function etc?
I am slowly getting more familiar with Access but still come unstuck on the simplest of things at times.
My database has a text field "Status" where the text is either, A, W, C. There is a form to update this field; currently it uses a standard Access created text field. The users want a checkbox which will show up as checked when the status is W, if the status is anything else, the checkbox will be blank. If the user clicks the checkbox within the form the status will be changed to W.
If [table.status] = 'W' then checkbox = 0 else checkbox = -1
1. After my relationship table is built, is it possible to have some tables automatics fill in according to what another field in the table is inputed? EX: I have a Ordertable(orderID,itemID,Itemdesc), and a Inventory table(ItemID,Itemdesc), When you select an Itemid to put in the order form, the order Description from Inventory would appear in the Itemdesc of the order form.
Is this possible? If so how?
2. In tables, is it possible to make a cell = to something? So like if I wanted to add a subtotal and a final total after tax, I could use = * .08 or something?
Can I fill all cells in a column that dont contain any data with the same value?
I have a table with about 1000 records, I have a column called "brand", half of the records contain some data but the other half dont and I really the ones that dont to contain the text "none".
I am trying to self teach myself and I am sure I am going about his wrong.
I have a form with a fillable text box called ProcessCode, a drop down box called CostContainerSize, and a fillable text box called disposal cost. Their are dozens of possible process codes and container sizes of 55,30,15,5,P,Y etc... I want the disposal cost box to auto fill based on Process code and disposal cost. I wrote the following in the control source IIf([ProcessCode]="LF" and [CostContainerSize]="55","$65.00") THis works to auto fill, but obviously only for that particular set of parameters. I have tried adding "or " comments to include other sizes for that particular process code with limited success. I have tried IIf([ProcessCode]="LF" and [CostContainerSize]="55"or"30","$65.00"or"$50.00") among other variations.
