Can't See All Forms When Importing To DB
Aug 30, 2005
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.
View Replies
ADVERTISEMENT
Jun 12, 2007
I am having a problem with importing text from one form to another one. I am logging into the company server and getting the database from there. But for some reason the text will not import on my machine but it will on others. Any help would be greatly appreciated.
View 1 Replies
View Related
Mar 31, 2008
Okay, so I just got a big project dumped into my lap to rebuild a database that was lost. This DB would import data from a couple excel spreadsheets and a text file, compare them to find any records that are missing from one or the other then spit that information back out in two reports. To make things harder, the person who uses this DB isn't the most computer literate and needs to be able to do everything with the push of a button. For this project I'm using Access 2003 with a possible need for 2000 backwards compatibility
First Issue: Importing. Is there ANY way to save an import so a macro could run it without the user doing anything? The other option is linked tables, but is there any way to update the data in those links because some of it needs to be changed. Also, can linking combine two excel spreadsheets into one linked table?
Second Issue: Information updating. As I mentioned before there is some information that needs to be updated before we can do comparisons. There is a field in both record sets that could be used for comparisons except for the fact it is formated all wrong.
In the excel spreadsheet it is set up as just a string of numbers like "3125" or "55879", but in the text file they added some preceding digits to this number code. The text file adds "HM" and a number of 0s to each number so that the field is a uniform 10 digits long. Like "3125" would become "HM00003125" and "55879" would be "HM00055879". So each record needs to have this data either added to it or trimmed off. The problem here is the variable number of 0s. I created a macro that would use the Len function to test how many zeros need to be added and update the field, but it can only run on one record at a time.
What I need to do is have either a trimming or adding updater for that field that runs in the background (either through the macro button or when loading a query) to make those fields compatible. It also would be preferable to work through linked tables.
Thankfully, there isn't any sort of rush on this paticular project. If you have any advice on any part of this project, please post
Thanks in advance
View 14 Replies
View Related
Mar 31, 2015
When I import a form with the Navigation control on it The following attributes of the navigation buttons are changed to #FFFFFF:
Hover Color, Pressed Color, Hover Fore Color, Pressed Fore Color
I was hoping to be able to automate the updating of customers databases by sending them a database which would export the required objects rather than the whole front end database. I can think a way around this by including code in the form so that it changes the attributes to the desired values, which are:
Accent 1, Accent 1, Background 1 and Background 1. But I would rather not have to do that.
It is interesting to note that the Border Color attribute is not changed on importing.
View 1 Replies
View Related
Mar 12, 2014
I inherited a defective Access 2010 and am now attempting to import a RECORD consisting of fields of xls data.
I am attempting to import from an existing Form Datasheet so that it overwrites (or appends the new data to the datasheet) from another identical Form Datasheet because it contains an additional 1000 contacts in it.
I have resulted to Using an .mdb file from over a year ago because the current .mdb keeps hitting "The Microsoft Access database engine could not find the object (Error 3011)"
My initial opinion is that the more recent .mdb it is corrupt.
View 4 Replies
View Related
May 12, 2005
A 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
View 2 Replies
View Related
May 11, 2006
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 Related
Feb 14, 2008
I 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?
View 4 Replies
View Related
Nov 27, 2004
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...
View 3 Replies
View Related
Apr 3, 2006
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.
View 2 Replies
View Related
Jun 9, 2007
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
View 1 Replies
View Related
Aug 3, 2005
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 Related
May 25, 2005
Hi
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
View 14 Replies
View Related
Jun 10, 2005
Have can I apply individual photo's to members records.
One photo for the one person in each record.
Foxy
View 4 Replies
View Related
Jun 15, 2005
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
View 2 Replies
View Related
Jan 17, 2006
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.
View 5 Replies
View Related
Feb 27, 2006
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:
View 3 Replies
View Related
Jun 6, 2006
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 Related
Oct 24, 2006
Hello 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.
View 1 Replies
View Related
Nov 20, 2006
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
View 4 Replies
View Related
Feb 24, 2007
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
View 6 Replies
View Related
Mar 6, 2007
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 Related
Jul 16, 2007
Someone 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?
View 14 Replies
View Related
Sep 6, 2007
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?
View 1 Replies
View Related
Nov 14, 2007
Hi,
Another question on this database I'm working on.
I have my database pretty much ready to go, but they would like to import data from another access database into this one.
The problem I'm seeing is, I've been working so hard to normalize my database with the proper relationships etc.
The database I'm importing from, the data there are all stored in huge tables.
so for example in my database I have our main table, that holds all like data. Then my other tables for specfic data that then relate to the main table ID.
The other database has everything in 1 table.
I've created a query and got what I needed from the other database, but not sure how to import it into my main table, and have it so the 'specific' data goes into the right table, and so the Main_ID field points to the correct record in my main table.
I don't think I explained that very well.
Here is how my structure is in the new database
tbl_main
Main_ID
Code_ID
Effective_Date
End_Date
Createdby_ID
tbl_CCE
Main_ID
Codeinfo
etc
etc
now the old database, everything is in 1 table and I'm not sure how to break it down so after I import the table CCE/Main_ID is the same as the Main_ID in my main table.
I'm still not sure if I explained that very well....
View 3 Replies
View Related
Apr 11, 2008
Hello,
I need to import the data from one database into another everytime a form opens, I have some code which works:
Function GrabAccessTable()
DoCmd.TransferDatabase transfertype:=acImport, _
databasetype:="Microsoft Access", _
databasename:="\triggerwwwroot$AW@RDAW@RDOnline.mdb", _
objecttype:=acTable, Source:="Main", _
destination:="Table", structureonly:=False
End Function
The problem is that it won't surrently write it into an existing table, I want it to write into a table called Table (stupid choice of name I know....) but instead it creates a new table calle Table1.
Thanks
Richard
View 1 Replies
View Related
