Hello.
I've saved a SQL instructions file from Oracle's Querry Builder. I was wondering if it was possible in any way to import those instructions into a Ms Access query ?
Thanks,
Marc-André.
MarcAndre_Carpentier@ssss.gouv.qc.ca
:cool:
Hello,
I'm new at this, but here goes. I have a memobox on a form that I set the DefaultValue to display instructions for what to enter in the memobox. I would like these instructions to be visible until the user clicks or tabs into the box. Then I would like these instructions to disappear when the user begins to type something in. I've tried using several different event scenarios, but none does exactly what I want. I don't want to use a control tip as it won't appear until the user actually enters the memobox and I want the instructions to be visible before that time. However, this is what I've done at this point because I haven't been able to fiqure out how else to do what I want to do.
Any help would be appreciated; I'm sure this is something very simple for all of you, but I've spent several hours trying to work my way through this.
Thanks, Charlotte
P.S. I've read many of the posts, and have gathered many helpful tips on a variety of Access topics. Thanks to all of you out there!
I would like to add some instructions for users of a form. Any easy way to accomplish this?
View 2 Replies View RelatedI have set an on click for a combo box to update a text box, the problem is the textbox lags and doesnt display the right information in the box until i either click onto the text box or refresh the screen..I only have one event procedure attached to the combo box
Private Sub Combo24_Click()
Me.TruckNumID = Me.Combo24.Column(0)
End Sub
I have several subforms with the same functions however this one is the only one that does this
I need to display some of the insruction lines in unbound / bound text box that will gradually moves up.
Example :
"This multiuser client server db is licenced to "ABC & Co.". This sofrware is to reduce cost of production and it increases speed of your production process more...."
These instruction lines may be arojnd 10-15 lines. I need to display it as non-stop moving up text massages on the main form once the data base is opened.
Is this possible? How?
With kind regards,
Ashfaque
I want to display the license agreement, which is a one page Word or PDF document, in form or report or whatever.
View 3 Replies View RelatedA common tip on this forum to reduce a db FE is to create a new db and import in from the original. Easy. Now I have done this and on navigating through the new db have no trouble when new. I then put in the start up form and close it. On start up again I get the following message. "Error accessing file. Network connection may have been lost". When trying to view any VBA coding the same message appears.
All tips or directions to other treads welcome.
Thanks
I imported a database designed several years ago into Access 2003, but all that I got was the tables. Is there a way to get the reports, queries, forms, etc? Thank for all the help.
View 2 Replies View RelatedI have an xml from the powers that be in IT: can post it here if anyone wants, but it's quite big. Tried to import it into Access 2003, no joy. Than I realised that it it's almost certainly attribute-centric.
http://support.microsoft.com/kb/285329
And so I need to create a template to make it look normal. although they give an example on the microsoft page, it's bespoke to the xml they create from Northwind and i'm struggling to write a template from scratch.
The xml appears to have tables embedded and all sorts, it's not just a flat file structure....
can that be reversed out with a template?
Hi, I want to automatically import an .xml file into a table that i have in my .mdb. Is this possible and if so, how do I do it?
If you could point me in the right direction that would also be great.
Thanx in advance...
I am trying to import into a table a very large text file that has information dumped into it every morning from a daily import.
I am building a database that is also using the same information but on a stand alone database and was curious to know if there is a way to link the txt file to a table so every morning that the new info is imported it will just automatically dump into the table.
I have filling this is not since it is a txt file and I will need to just setup a custom menu button that when pressed does the import into the table, but I was hoping it would be as simple as a link.
Thanks ahead of time.
I am importing from a spreadsheet. The column is formated as text.
In the design view of the Access table for the associated field it is showing text.
When it encounters a record that is all numbers and no letters it imports it as an exponent
i.e. 32986698 is imported as 3.29867e+007
What can I do to correct this?
Thanks
Bill
When importing excel spreadsheets to access, I am getting the message subscript it out of range. What do I need to do in order for the spreadsheet to be imported?
View 2 Replies View RelatedHi
I am having much trouble importing csv file into access 2003
My freewebs site have a registration form
The forms are then downloaded into my pc as csv files
According to freewebs, the csv file is access friendly and can be imported into access
so I tried for about a million time and still no luck
where did i go wrong?
this is what i did
help !
regards
frontpageplanners
Have can I apply individual photo's to members records.
One photo for the one person in each record.
Foxy
Hi all,
My boss and I were trying to import some data from a .txt file there is a deliberate mistake and we were trying to get a input mask/validation rule to stop that particular record
thanks,
Dellero
I'm having trouble with a DB that I've been using for four years in a multi-user environment. (Windows XP; Access 2000; Novell Network) Started with one user as she got a new WinXP PC (had Win2K - not totally convinced that she didn't have the problem before the new PC); she wasn't able to do a keyword search - it would bring up every record, but other users were fine. Then, it started to do it on my PC as well (WinXP - even though I had my XP for a year longer), but other users are still fine. My code still looks fine, and apparently works for others.
So, thinking there may be some corruption going on, I decided to create a new DB and import in tables, queries, forms, reports, and modules. Only three of 20 forms show up as options to import and only a portion of the reports show up. All the tables and queries appear. When I go back to the "faulty" database, the forms are there and do work from my "menu form".
Then, I tried compacting the "faulty" database, but I don't get the message in the lower left saying it is compacting; the hourglass comes up, then the DB opens - the size stays the same. So, I don't think it is compacting.
Any ideas ????
Thanks - and I do appreciate this forum - has saved me alot of time over the years.
I have a linked csv table into access, and have a make table query which runs off this. When i first build and run the query it runs fine, but when i run it again I get the following problem "numeric field overflow" I have checked all the data types, they match fine.....
The thing that i cannot understand is when I rebuild the query from scratch, it works fine for the first couple of times, then stops.
Hi! I've got a problem with a csv file from our MRP system. It always contains spaces BEFORE the data in the fields and I need to ignore them when I group the data. The crosstab report works absolutely fine but I don't get the right output because of those darned spaces!!:mad:
HELP!!:confused:
I'm using a combo box control for searching employees. Which the empID is the unique key, the form is scrolling each record, do not want it to do that. When i click on an ID, it only changes ID's but not the information thats tied to that ID. How can I fix that? any valuable information is well appreciated. Thank you
View 3 Replies View RelatedHello all,
I'm fairly new at access and have been stumped at this problem.
I download a csv file from the internet and what i wanted to do is just imported straight to a table from access. Some how the csv file contain some excel function that looks like the follwoing - i.e. =T("SOME TEXT"). Access can't import the file and i'm unsure of how i can do it. Does anyone have an idea of how i can do an import? Thank you.
hi all
i have an excel sheet in comma delimited form. the fields in access have input masks set, but when imported into access the masks are ignored - does anyone know a way around this. Also is there anyway to get access to tell me what records its rejected when it comes accross one that breaks a validation rule
Thank in advance
Matt
Hi All
I import data from exel 2000 into access 2000 how can I remove duplicate and unwanted data (ie Blank rows)
I recieve my daily work via an e-mailed exel spreadsheat which is then transposed before being exported to access.
I have allowed for upto 12 customers per day in my transpose macro.
The problems
1. If I get routed 5 customers I am left with 7 blank rows when I import into access.
2. If a customer is for example is not home and I am routed the same customer at a latter day, when I call up their info in my WIP form I normally get the first date the customer was routed this records the WIP at the wrong date therefore upsetting searches by date.
How can I remove the blank rows.
How can I sort and remove earlier routed customers leaving the last date.
Thanks
Geoffk
Guys I don't know if any of you have done this. I need to import a formatted excel file into an access table, I know that I need to write a vba code to do it, can someone please give me a tip or an example. The excel file is a formatted form, it's not based on columns & rows!!!! Please Please assist.
View 1 Replies View RelatedSomeone recently answered my query with regards to uploading data to an access table.
The first coloumn is an auto incremented number.
Will there be any problems with importing data - when one field is auto increment?
Obviously I wont be uploading values for this column - can that be done?
Access 2002.
Hey guys-
I have a software program that I am exporting data out of into excel (it's SQL based). From Excel, I then am importing into Access into an existing table previously created from a similar file (same columns, just different record sets). I am running into problems when importing files...
If I import into a new table, and have Access create the table based off of the Excel file- it works fine. If I try to import more records into this same table, it tells me it failed to import and that an error occured (no error's table created, no error number given). If I delete the original records in the table, and re-import the SAME RECORDS that were originally imported to create the table- it doesn't work. It will only import my files if it creates a brand new table for each import, every time.
Can Access not import into an existing table? It should- but I dont get what's going on here. I have tried DBF, HTML, txt files- all the same results. I really don't want to have to create a new table each time- as now my Queries will have to be updated everytime I create a new table. Can you please help?