Hi guys, hope you can help.
I have two fields (that I'm interested in) in my table: Insurance Policy End Date and Reminder Date.
I would like the default value in the reminder date to be exactly six weeks before the value entered in Policy End date. I'm not at all sure how to do this with the expression builder. Could you guys nudge me in the right direction?
Eternally grateful.
I have a subform on a Customer Data form for Phone Numbers (in order to normalize the data). Is there a way to display a subform in a format other than datasheet view? I only want to have space for 3 phone numbers, so a datasheet isn't necessary - I would rather the subform blend into my form instead.
I have read this: http://support.microsoft.com/?kbid=216675 , but it is not what I am looking for, (or I can't get it to work) I have searched the forum - with no luck, formatting subform posts all seem to do with conditional formatting.
Thank you!:D
just a quick question guys,
If i had two tables;
tblCar
CarID
CarName
tblDriver
DriverID
DriverName
how would i put these into a tblCarDriver, would i be right in creating
tblCarDriver
CarDriverID
CarID
DriverID
then how would i set up the fields for this table?
e.g when i use the lookup wizard for the CarID & DriverID fields in tblCarDriver would i select all fields from the Car table and all fields from the driver table or just the CarID from the Car table and DriverID from the Driver table.
How would i show this in a form!!!! maybe by query and a dropdown box?
(e.g Ford, Dean Welch)
Thanks in advance....
Hi
I know this is probably a silly question but I had a number of checkboxes in a table and had set their default value to be 0 however I did not do this in the table properties of these fields.
I can understand some things like formatting dates in a form but storing it differently in the table but why did access not automatically input 0s in all the fields where I did not check the box?
When I try to transfer (ctrl c + v) data from a table in Excel to a table in Access it loses format.
Exemple: $ 1.000,00 (Excel) become 1000 (Access).
I need to keep the format to make sure that the code works properly.
Hi All,
The following code is supposed to insert a date formatted as dd/mm/yyyy into a table, when i view the mySQL string in the debug window it shows the correct format, however when i open the table it displays the date as mm/dd/yyyy.
The table's date field userdate is formatted as a short date field with an input mask of dd/mm/yyyy.
My computers date settings are set up as dd/mm/yyyy as well
Any ideas on hows to correct this?
Thanks in advance. :)
Public Function Test()
Dim mySQL As String
Dim dtDate As Date
Dim db As Database
Dim qdf As QueryDef
Set db = CurrentDb()
dtDate = Format(Now(), "dd/mm/yy")
mySQL = "INSERT INTO tblCurrentUser( userdate ) values (" & "#" & dtDate & "#" & ");"
Debug.Print mySQL
'*The debugger shows* INSERT INTO tblCurrentUser( userdate ) values (#04/05/2005#);
' However the value in my table tblCurrentUser is05/04/2005 is in mm/dd/yyyy format
Set qdf = db.CreateQueryDef("", mySQL)
qdf.Execute
End Function
Here is my problem:
Let's say that I have a table with a field name of "Phone Number". I input about 200 #'s in the following format: xxx-xxx-xxxx. I decide that I want to use the an input mask to create (xxx) xxx-xxxx. I input 50 more #'s. The previous 200 have the old format while the 50 recent #'s have the new format. How can I update the entire field from the old format to the new without reentering the data? Or can I? If I can, will the change also apply to any forms created off of this table?
Thanks
The transfer spreadsheet function only allows one to export a table from the database to an excel file format. I want to output the table to a file in csv format using a simple function. Is this possible ?
View 1 Replies View RelatedGreetings all,
I am probably just being dense.
But how do I go about entering a percentage of say 5% in a numer field formated to percentage in a table?
If I enter 5 in translates to 500%, .05 as 0!
Thanks,
Brian.
Zimbabwe.
I know in creating columns in a table where I have date/time you can select long short, etc. But, I want my column name to be YR and the values of 2014, 2015, 2016, 2017 all the way to 2020. So I end up with 7 rows. Then another date related table that houses the months. It will have a column name of MTH and the values Jan through Dec so a total of 12 rows. I have tried in format putting YYYY and MMM but when entering the data, it gives me an error saying I have to convert, click the calendar and choose a date. I don't want to choose month, day and year. I just want the year.
View 2 Replies View Relatedhey guys quick one
when creating a table in SQL how do you set a variable to yes/no i tried the BIT command but didnt like that so is there any other way?
cheers guys
I guess this is pretty fundamental but I cant get it right! I want to search for a member by post code so I need to have validation for my table field post code so that when my parameter query accepts the post code input records will be returned covering all input types e.g. Users can put in CF72 (space)9AD or CF729AD and still get the same records or alternately how do I make users enter Post Codes with the correct UK spacing i.e 4 characters a space then the remaining characters?
View 7 Replies View RelatedA lady at work created an Access database that imports a dBase 5 file and when I go to import this file on User #1 PC it gives the error;
"External table is not in the expected format."
I can use the same Access database and same dBase file to import (stored on a shared network drive) from User #2 & #3's PC's and all works well. The only problem is that it is User #1 job to do this.
I unloaded Access 2003 and reloaded it and still the same results. All 3 PC's are identical via hardware and software.
It use to work until this past Tuesday when it started to give the error.
My steps are:
open the "Sales" Access database
select the prices table
Get External Data / Import and then select Prices.dbf
Then the error message comes up.
I am not an Access database guy and could use some help!
Thanks
WhooTAZ
I have set the Left([DSERDBA_RECEIPTS].[RCTH_RECEIPT_NO],8) AS [DISTRIBUTION DT] field property to Short Date, 99/99/0000;0;_ . When I run the query I get that field formated as a short date, but when I try to create a table from the same query the data returned is no longer in the date format. Is there something I can do to have the make table results look like what I get when I just run the query without creating a table?
SELECT
DSERDBA_RECEIPTS.RCTH_ID_CASE AS [CASE],
DSERDBA_RECEIPTS.RCTH_DT_RECEIPT AS [DT RCTH],
Left([DSERDBA_RECEIPTS].[RCTH_RECEIPT_NO],8) AS [DISTRIBUTION DT], DSERDBA_DISBURSEMENTS.DSB_DT_DISBURSE INTO [TABLE 1]
FROM [UNIVERSE OF CASES] INNER JOIN (DSERDBA_RECEIPTS INNER JOIN DSERDBA_DISBURSEMENTS ON DSERDBA_RECEIPTS.RCTH_RECEIPT_NO = DSERDBA_DISBURSEMENTS.DSB_RECEIPT_NO) ON [UNIVERSE OF CASES].STAT_CASE_ID = DSERDBA_RECEIPTS.RCTH_ID_CASE
WHERE (((DSERDBA_RECEIPTS.RCTH_ID_CASE)="20028570P"));
How can I do this? There doesn't seem to be an member of Field called format. Why is this? I want to make the display on a Boolean field, in a Table made from a Make Table Query, to Yes/No, rather than default 0/-1.
View 7 Replies View RelatedMy Access DB has two tables linked to excel spreadsheets. Excel is the only way I can acquire this data from another source. The Excel spreadsheets update themselves on a regular basis.
My problem is that one of the fields in the spreadsheet needs to be formatted as a date and I have been unable to get Excel to handle this automatically.
Is there some way that I can date format a field in a table that is linked to an Excel spreadsheet?
Unless I can figure this out, I have to manually be involved with each Excel Update.
Thanks in advance.
I have an issue with queries not showing sufficient decimal points, even though the underlying table does have the formatting I desire.
If I open Table 1 directly, for Field 1 I have a value of 0.1439254445378153860918842318 using a format of decimal / fixed / Precision: 18 / Scale: 0 / Decimal: 2 and it shows in the table as 0.14 until I click on the cell in which case I get the full value above.
This is how I want it to show (0.14). When I run a query on this table, not setting any formats in the query, I get 0.00, and clicking on the cell only provides a result of 0. I've tried a ton of different underlying formats on Table 1, and been unable to get a different result...
1. I am trying to extract table from Access in XML format. On completing the extraction, the XML disappears from the folder where it was stored.....
2. Also, How do i see SQL query for table in Access... the SQL view option is not seen in the ACCESS dropdown.
Hey guys, I'm just doing this database and have suddenly realised I dont know as much about MS Access as I thought!
Q.1 - I need to run a query that displays the top 5 records in a table, how would I go about doing this?
Q.2 - In my tables, I have of numerical data like the following...
http://img276.imageshack.us/img276/2695/11ch1.png
is it possible to make a Totals column which automatcily adds up the data in the Fraud, Competition, Loss of data, etc rows? (similar to MS Excel if possible)
HI
I am creating this bloody db and I have created a form and when I open it, it shows, record no one, what I want it to do is open blank ready for a new bit of info to be put in. I know this is an easy one but im sick of the sight of access this week
With thanks
Hello
Great website. Does anyone have any information on the leafs (http://a-cholesterol-diet.com/index.htm). I have been looking all over the place but no one seems to have any information or listings of any websites, any help would be greatly appreciated.
Thx
I have done a little database for someone so they can keep track of available dates for their apartments in Turkey. They want me to add it to their website so people can look for themselves. I know I should join a beginners web design forum, but can anyone tell me how i actually log into a website? I have the wesite address and the password. Thank you in advance Ben
View 5 Replies View RelatedHi all,
I am just wondering why Modules have the name of bas at the start of the name. frmForm and rptReport makes sense but why bas for Modules ?
Thanks in advance,
Mitch.....:confused:
I just joined and wanted to say hi to everyone. Also, I noticed that the forum runs off my screen.
Anyone else notice that?
melanie
Hello,
one of tables requires me to store sickness details, the sickness codes are all unique, they do however start with at least one 0 for example code - 000003 Description Stress. When you enter a code access automatically trims of the 0's to leave a 3.
Is there a way to override this im unaware of?
i am using the following query to make a table. i was wondering if anyone knew a way to have the table be named from data entered into a text box in a different form. so when different people type in different names a new different table will be created. thanks
CREATE TABLE tbalename (First_Name TEXT(20), Last_Name TEXT(25), dob DATETIME, Constraint Employees_PK Primary Key (First_Name, Last_Name, dob));