I have a query that I manually export as a dbf file (i.e. right-click and export). I manually export because I export to a unique directory each time. However, fields in the query that are of type string always get exported with a length of 255. Is there anyway in SQL that I can set the width a query's text field to a specific value (so that when I export it it isn't 255 characters long)?
View RepliesI am running Access 2003 and have created a split form using one of the std form options. The file it is querying has about 20 fields per record. The split form that is generated has four columns of 10 fields each.
E.g.
Column 1 Column 2 Column 3 Column 4
Employee Fred Smith Weekending 24-June-2013
Age 25 Hourly_Rate $30.00
Normal_Time 24 Sick_Leave 8
Vacation_Hrs 8 Total_Hrs 40
etc
etc
Field10_Name, Field10 Contents, Field20_Name, Field20 Contents
When I view the form generated, some of these fields are too narrow and others are too wide. I would like to make the width of the fields various widths. But if I try to widen one field in the column all fields in the same column are made the same width. It appears as if they are multiply selected. Is there any way of selecting a single field and varying the width without impacting fields above or below it in the column?
hello all,
I was wondering whether there is an "easy" way to make the column widths of a list box to adjust to the largest peice of data under it.... without filling it in yourself in the design view... So in VB....
I know that there is the property COLUMNWIDTHS, and that you can adjust it by calling that property..
But how to make it the column width to adjust automatically to the largest piece of text in that column??
Any ideas would be welcome...
tnx
Zurvy
Hello, all.
I need to use a datasheet view for a subform, but I can't seem to find how to keep users from editing the column widths within the view. Help?
THANKS!
Tom
im trying to autosize list box columns depending on the size of the largest field in the column?
View 1 Replies View RelatedI am using Access 2013 (but I assume that the solution for Access 2010 will apply).
Here is the situation:
1. I have a simple datasheet form with three columns
2. I need to adjust the column widths so that all the text is visible
3. When I adjust the column widths, save the form, close the form, and re-open the form, the column widths reset
4. I need the column widths to either 1) stay the same as they previously were, or 2) be wide enough to fit all the text in each field
i have a subform on a form with Source Object="Query.myquery", my form is generating a sql string dynamically and assigning this sql string to the RecordSource property which works fine. But now if the user changes the width of the columns in the subform and close the form , a prompt is thrown asking if the "myquery" needs to be saved. I dont want to save the settings of "myquery" but at the same time avoid this modal dialog. If i use DoCmd.SetWarnings=False , i dont see the warning anymore BUT the query gets saved.
I am using "myquery" to just display column names in the subform when the forms loads and also without it i cant directly use RecordSource property in my code.
any suggestions?
I have a numeric field (long integer) in a table. I've set the format to fixed. No matter what I set the decimal places to, auto, 0 or 2, when I enter a value of 0.71, it displays as 1.00
In my form, I've also set the field property to fixed, but it displays the value as 1.
I have tblDefaults that has only one record, containing default values. Next I have tblWebpages that has a Memo field that holds my html data. Lastly I have a Form called frmCreate with a field called Webpage. This Form is based on a tblCreate table.
Whenever I click a command button on my Form, I want to populate the Webpage field on my frmCreate Form with a template from tblWebpages. The template to chose will be based upon the WhichTemplate field in tblDefaults.
In brief, tblDefaults tells me which is the current webpage template and so the field should be populated with that html data.
Phew!
Thanks,
Jon
I am creating a table with a field named Payment ID. I want the table to increment the number of this field automatically when the user is trying to enter a new record, i.e. set the field as an autonumber.
I know that this is very basic, my MS Access skills is really limited.
Cheers.
Im not sure if this is the right area to post this but what i wanted to know is how i would set the field "status" to OutStanding when a record is added into the table.
View 2 Replies View RelatedOk I'll premiss this by saying it has been many years since I have done much with access so I have forgotten alot and alot of things have changed. However I have been using Dataease alot but switched companies so am back to access.In dataease if I had a form called projects and that form had three fields (employee ID, employee first name, employee last initial) that pulled data from another table other than the projects table I would relate them via the employee ID. projects form employee ID = employee form employee IDthen for the two other fields I would have them lookup their data by using the employee id.projects form employee first name = if (projects employee ID = employee employee ID) then lookup employee employee first name. And the same for the last initial.The question is how do I setup for fields for first name and last initial to do the lookup in access.Employee ID TableEmployee ID #Employee First NameEmployee Last InitialProject TableEmployee ID (linked to employee id table)project idproject nameproject discriptionproject start dateproject end dateproject formproject idproject nameproject discriptionproject start dateproject end dateemployee ID (must match employee table employee id)employee first name (read only field that looks its data up from the employee table based on employee id)employee last initial (read only field that looks its data up from the employee table based on employee id)
View 1 Replies View RelatedI have two tables relating to People
PeopleType: ID and description (e.g. 1 student, 2 teacher, etc)
PeopleDetails: PeopleType.id, name, gender etc
I have a form that contains subforms
On the Main section of the form the data comes from the PeopleDetails. I want the user to fill in this but I want the PeopleType.id to be set to e.g. 2 so that you can only key in teacher details.
I have been trying to set it using a macro SetValue but i cannot get it to work.
I have a form to enter attendance in that pulls students from a StudentEnrollmentTable based on FacultyName which is selected from a combobox that runs the following code:
Private Sub cboInstructorName_Click()
Me.Requery
End Sub
A query (StudentAttendanceBYFaculty) is run each time a faculty name is selected. On the form their is a field name TempClassesAttended which is bound to a field of the same name in the StudentEnrollmentTable. Teachers will enter attendance data and run an append query to append the current form records to the StudentAttendanceTable. Each time the form is repopulated the most recent TempClassesAttended values are pulled into the form. This is what is expected.
Now I want to load Null values into the TempAttendance field on the form each time the Faculty selects their name and runs the event. I looked at code online and it seems easy enough, but I don't know enough to make it work. This is the code suggested:
UPDATE TableName SET FieldName = Null
OR
UPDATE MyTable
SET MyField = Null
how to include this into the current event so that the event will return the faculty records with Null values in the TempAttendence field.
High all.
I would like to know how to set a fields default value on a table.
Eg - i have a Yes/No field that and i want the default value to be set to 'Yes'.
I cant use the front end application because the form its on is a generic form used by about 30 other tables.
At present it is not set to anything and so always defaults to 'No' on the form.
Thanks in advance.
I have a membership database. A number of members go by their middle names or a nickname rather than their first name. I need to keep track of their real full names, but I want the new-record default of the preferred name field to equal the contents of the first name field. How do I set this in the table design? The table already has 1400 records, and it would be quite a job to manually copy each first name to the preferred name field, a job I would rather avoid.
View 5 Replies View RelatedHi All,
I have only been playing with MS Access for a little while and I do not know all there is to know yet so I figured I come here to ask a question.
I use MS Access in web design and lately I have been experiencing a problem with my registration form which inserts new users into an MS Access database table.
Lately my registration form has become a target for spammers trying to inject spam in the form of html code into the password field of the online registration form.
I figured that I could deter this from happening by only allowing the letters A - Z and numbers 0 - 9 in the field and not allowing characters like < > and ? and ".
I assume I can do this with a validation rule but I'm unsure as to how I would go about setting this up. Limiting the field size to only 50 characters does not seem to work unfortunately.
Any help on how to set up a validation rule would be appreciated.
Thanks
Mechaworx
I know its probably a simple one but I am new to access, so...
I have a simple membership database and in it I keep a record of who I am expecting to attend on a particular date. This is achieved through having a seperate field for each meeting on a simple yes/no type.
I would like to be able to print a report from a form for a particular date showing everyone that would be attending. I have a list box that shows all the fields. What I cant do is set the date I want in the query from the report, can anyone help?
thanks
How do I go about getting data from a:
Text field in Form 1
Clicking a button to run VBA code, and Automatically inserting it into a refreshed combo box in Form 2
I've also attached a pic.
*Also, I'm using Access 2007...
I have a table [Employees] which has the following Fields
- TxtEmpID
- StrEmpName
- StrEmpPassword
Which I use for my login table with the following script:
If Me.txtPassword.Value = DLookup("strEmpPassword", "tblEmployees", "[TxtEmpID]=" & Me.cboEmployee.Value) Then
TxtMyEmpID = Me.cboEmployee.Value
On my form the drop down to select the employee is
SELECT tblEmployees.[TxtEmpID], [tblEmployees].[strEmpName] FROM tblEmployees;
(Seemingly all this is based on the TxtEmpID)
When I create a Temporary Variable
[SetTempVar screen.activecontrol with the name SetUserID]
And then want to place the variable in a form or whatever else, I can only see the TxtEmpID. I would like to set the TempVar as the field StrEmpName.
I am "OK" when it comes to figuring out a formula in Excel, but Access is much different for me. I am looking to set up a calculated field in a report.
The result is find the Client-to-Staff ratio but there are two possible conditions:
CONDITION 1: If VacantFTEE = 0
ActiveClients / (DirectFTEE + DetailedFTEE + ProvidedFTEE)
CONDITION 2: If VacantFTEE > 0
ActiveClients / (DirectFTEE + VacantFTEE + DetailedFTEE)
I am presuming I need some sort of IF/OR statement to make this as 1 formula, but I can't seem to make it work.
how to set the Field Size in a new Table. I need the user to be able to type in 17 characters (as in a vehicle VIN). I don't want the user to have the ability to type in anything less than 17 characters or anything more than 17 characters.
View 2 Replies View RelatedI have an Access table with a field called Purchase Oreder Item. The field must be all numbers and the length can be from 10 characters to fourteen characters. I have no problem requiring all numeric characters with a validation rule and setting a maximum length with the input mask. The problem is requiring the minimum of ten numeric characters. The operator must enter a minimum of ten characters and no more than fourteen. Please help.
View 4 Replies View RelatedThe data that is to be entered in the field "Rank", is either RK1, RK2 or RK3
How would I make the validation in a table make the user enter the format RK(Number), with only numbers from 1-3?
Thanks!
Hi,
I export a query as csv to upload to another database on a web site. When that csv file has been exported I'd like the query to be emptied, so that the next time I export I don't export duplicates. What's the easiest way to do that?
I've been thinking of having a field in the table with a check box that is checked when the file is exported. The query then selects only those records where that box is not checked.
But how can I check those boxes on Export rather than when I run the query? The reason being that I may want to preview by running the query, without having that affecting the check box.
Hi everyone,
Please would someone be able to help me?
I have created a union query however, one of the columns, has not picked up the same format as it has in the tables. As in the tables it has this format
'00000'.
Please woud you be able to advise me how I can change the format on one of the 'columns' in my union query. As one column is 'numbers' and the other is 'text'. I need to change the number column so the format is '00000'.
Thank you in advance for your help.
Nats