I came into a database where the forms have checkboxes connected to table fields that are in text data type. I see that when the checkbox is checked, the value in the field is still -1 in the table. Is there a reason to change these fields to Yes/No data type or just keep them as they are? Are there limitations or problems to having Yes/No values (-1) in a text field?
View RepliesHad a combobox so the user could choose between two data entry formats.They don't want the combobox, they want the user to enter data into one or the other textbox - and that choice to trigger the format.Two groups of text box - group 1 has a single text box - group 2 has three text box. When the user selects a text box and types the first character into it. This triggers locking out the other group choice and enables the <Validate and Edit> command button.
If the user backs out (deletes) the text in a text box.It basically makes both groups available again and it disables the <Validate and Edit> command button.Basically, if the text box Change event counts a character, it changes the text box Tag to "Bust". Then it calls a common routine that checks both text boxes.The choice won't take place if the textbox gets focus. It changes if a text box has 1 or more character typed in.
Code:
Sub WhosOnFirst()
' two groups of Required field - if one textbox in a group has a character entered first
' that group becomes the Format - enables the <Validate and Accept> button that will take the next setp
[code]...
I have a linked database that stores date values as YYMM in text format. I have no control over how that information is kept. I cant seem to find a way to convert YYMM text to date format. Additionally I would like to add the last day of the respective month to that data.
View 6 Replies View RelatedI am building a database using data imported from Excel workbooks. The dates in the workbooks are formatted as text in the YYYYMMDD format. Is there a way to convert this into date format during the import or after? I am pulling in a lot of different workbooks and trying to avoid having to reformat each individual workbook prior to importing them.
View 3 Replies View RelatedI upgraded to Access-2010 and the Text File Import function will not recognize dates in the format YYYY-MM-DD. The import dialogue sees enough to recognize the field as a date, but then every date encountered is written to the Import-Errors table. This is true whether the file has a .txt or .csv extension. The actual file format is .csv.
View 6 Replies View RelatedI have two tables(see below). I want to set up a query, link these 2 tables together. I set a one-to-one relationship between Client ID in two table. But got error message :"Type mismatch in expression".
I tried to change Client ID data type from "Text" to "Number", then Access deleted some data under Client ID in Order table.How can I make this work, but not having to re-type in all data?
Client Table:
Client ID(Autonumber)
Client Name (Text)
Client Address (Text)
Order Table:
Order ID(Autonumber)
Client ID(Short Text)
Unit Order(Number)
Unit Price
I have a table with about 300,000 records. About ten fairly small fields per record. I am trying to change the length of a text field from 25 to 40 characters, and I get the error message, 'MS Access can't change the data type. There isn't enough disk space or memory'.
I have never seen this message before. I have about 64 Gig of free disk space. What can I do?
I want to format the text using format function. how i format the word apple to "apple" (With Quatation mark).
str = Format(Me.word, xxxx)
The DB this info is pulled from stores the NAME field in all caps.
My query returns the name like= JAMES JONES
Is there something I can do to change the name format to James Jones?
SELECT
[OPEN CASES].CASE,
[OPEN CASES].[MEMBER#],
[CLIENT TABLE 2].NAME,
[CLIENT TABLE 2].A1,
[CLIENT TABLE 2].A2,
[CLIENT TABLE 2].ADD INTO [MEMBER CASE TABLE]
FROM [CLIENT TABLE 2] INNER JOIN [OPEN CASES] ON [CLIENT TABLE 2].MEMBER = [OPEN CASES].[MEMBER#]
WHERE ((([CLIENT TABLE 2].RELATION_CODE)="C")) OR
((([CLIENT TABLE 2].RELATION_CODE)="S") AND
([CLIENT TABLE 2].MEMBER_CASE_STATUS)="A"))
ORDER BY [CLIENT TABLE 2].ADD;
Hi, I'm newbie.
I did create LANDesk Date Control in the form but the date format shown MMDDYYYY.
I want change the date format to DDMMYYYY...how?
& how do I link the LANDesk Date Control into tables as database?
p/s - can I change font color date of "Sat" & "Sun" to red color instead? Please guide.
Thanks.:D
Hello. I'm triyng to change every field format in a Form each time I jump from one field to another. I want it to get grey and bold when it got the focus
I managed it with a GetFocus and Lost Focus for each field but whena form has a lot of fields it gets "a lot" of programing.
Is there a way of doing it another way, for instance On current
Thanks
Hi all,
I had a form with a command button which invokes email sending option to send a report..I am using code from a sample database . The code which I am using is here:-
'This will create the e-mail
DoCmd.SendObject acReport, "Rpt_Customer", "RichTextFormat(*.rtf)", "", "", , "Customer Report", "", False, ""
'Tbis explains all the section of the e-mail see SendObject in help
Rem example from help DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]
The code is working perfect and my question is that can I change the file format from RichTextFormat to word format????? I tried by chaning "WordDocument (*.doc)" but it didn't worked???? Is there any way I can change that to word format (*.doc)???? any suggestions appreciated .
thanks in advance
Thanks
I have a "make table" query. Inside that query there is a simple expression that divides two fields by one another to arrive at a %. Example 5/100=5%. However, the data returned is not in a % format.I know that I can go into table properties and change the fromat to "percentage", but that will only work for the current table that I have created. Once I re-run the "make table" query, I lose the change to the format, and my value again returns to a number, not a %..
Is there any way to always have a percentage returned without having to manually change the format each time that I run the query, or having to make a "delete" and "append query" ?
I have a table that contains information along with a field named "Date Input" and then a calculated field called "Due NLT Date". New records are appended to this table daily. The calculated "Due NLT Date" field is simply "[Date Input]+5".
In some unforeseen circumstances the "Due NLT Date" field needs to be extended to 6 or 7 days from the "Date Input". I am trying to find a way adjust the number of days using a command button/VBA getting the desired number of days either from an input box or from a txt box on a form.
I have been playing with using SQL ALTER TABLE in VBA but can't get it to work.
I'd image it would look something like this but how to write it correctly:
RunSQL ALTER TABLE "table" FIELD "field" to calculated "[Date Input]+ & input box "Enter number of days""
First off a big thank you to this forum... have solved a lot of questions I have had and some I never knew I had. Keep in mind this is all from a non-programmer so my question(s) might not be technically sound.
The issue I have is I have built a database to track documents that we process. It is uses an autonumber and that has worked great. The issue is eventually this document gets processed in our accounting system and I want to retrieve data from there and add it to the document record.
I figured out how to like the ODBC database and that worked, but I get an expression error. The field in the ODBC database is text and in Access it is an Autonumber.
Is there a way to copy the autonumber field and change it to text property to align with the other database?
All help welcome and appreciated.
In my query I have a date field and it is half UK british and half US. I have my regional date set to UK on my laptop.
how to change it to same date? I don't mind either, I just want it to be consistent.
I have a list of patients that are seeing various clinicians in a clinic. Currently everything is on paper and when a patient arrives we highlight their name on the list. So now that I'm finally moving everything paperless, I want to have the record become "highlighted" when I select patient has arrived. The only problem is as it's a continuous form, the formatting changes on all records. Here is the screenshot before anyone arrives:
Those are two separate records that you see. Behind all of those fields is a box coloured #E7F442 (optic yellow-ish). What I want is when I select "Arrived" from the dropdown, for the fields on the left (name, number, appointment type, etc) to become transparent so the yellow shows through and looks highlighted. I've used this code:
Code:
Private Sub ATCST_AfterUpdate()
If Me.ATCST = "Arrived" Then
Me.RGBCHID.BackStyle = 0
Me.PATNAME.BackStyle = 0
Me.TCDESC.BackStyle = 0
Me.VISPURP.BackStyle = 0
Me.ATCMNT.BackStyle = 0
Me.ATTIME.BackStyle = 0
Me.ATCST.BackStyle = 0
[code]....
Making the whole code utterly useless, as it's changing the formatting on every record. Is there a way to program this so the formatting changes only affect the record I'm working on at that moment?
I'm working on a purchasing database where if the user checks a box on a subform, another field needs to be disabled. The code works, but since this is a continuous subform, it disables that field on every row. Is there any way to make it stick to the row the user is working on?
Here's the code:
If Me!acs_puchase = -1 Then
Me!inventory_po.Enabled = False
ElseIf Me!acs_puchase = 0 Then
Me!inventory_po.Enabled = True
End If
Thank you!
I use expression on the query field, but after I run it, the field change its format from number to text, how to reformat on the query criteria to change the text to integer format?
View 8 Replies View RelatedI'm having a format problem. I have a query (Q1) that, among other things format a date field as YYYYMM (Field1).
I have a second query (Q2) whose data source is Q1.
In Q2 I need to link Q1 to a table but Field1 is being reformatted as text (confirmed by running a make table query).
I want Field1 to be Number format to eliminate a mismatch error.
I know how to change the format of a field in a table using VBA but I cant seem to find a way of changing the format within a query.
I have created access database having field currency but it shows currency in $ by default I want to changed it to Rupee. How could it do?
View 1 Replies View RelatedI am struggling to change the format of 2013-07-29 11:33:03.6160000 to show dd/mm/yyyy
View 4 Replies View RelatedI have a Form Display Data in my Access Database, which is working really well. However, users was asking if there is a way we can make Font Color Could/would change if The text in A field or Any field in my display form contained the word "SAD or MAD". Is there code for such thing in display form?..
View 3 Replies View RelatedHi All,
If it is possible to change the format properties of a menu/toolbar could someone please point me in the direction of some guidance/ let me know how to go about it I would appreciate it.
Specifically I'm trying to change the menu bar's /database window's property to match my forms (and company branding).
I've Googled various phrases in both UK and US spellings (to be on the safe side) and searched a few forums (this one included) and cannot find much beyond creating customised menu/tool bars.
Many thanks
Hi All
I have a database table with a long date format 05/08/1995
I am trying to think of a way to alter the data in a query so it shows 08/1995. without comprimising the field that says 05/08/1995.
any ideas? I can add a new field but not sure
I want to format the Telephone number input mask to show
(999) 123-4567 ext 1234
where the extension can be in 3 or 4 digits which is up to the user, or blank if none exists. . .
sorry,
this is one of those non intuitive sections of Access. . .
sportsguy