Trouble With Export Feature In Access
Sep 6, 2005
I have a form whose fields are calculated based off VBA code, including fuctions, SQL, etc. Because of the nature of my form, I cannot save the calculations to a table before exporting to and excel spreadsheet.
When I use the File>Export feature of Access and save to and Excel format, I am not able to change the format of my numbers in Excel. For example, I have tried to highlight some of my exported numbers, right-click, and change the format to currency in Excel (or even decimal places). In order for excel to change the format, I have to select the cell, place my cursor in the edit window, and hit enter.....then the format will change.....is there any way to avoid this?
Please let me know if this isn't clear, and I'll attempt to explain it better.
View Replies
ADVERTISEMENT
Sep 23, 2006
Periodically, I use the Access (2000) Help Tab (as a last resort) to get an answer. In certain situations I get the message "Selection not associated with any topics." For example, this happens when I look up in Methods Reference either "Connection (ADO)" or"Fields (DAO)".
I assume that this issue may be caused by not having a reference file checked under Tools in the VB window. Specifically references to DAO and ADO help files. I Have the "Microsoft ActiveX Data Objects 2.5 Library" and "Microsoft DAO 3.6 Object Library" checked. Also based on Allan Brown's (http://allenbrowne.com/tips.html) website, I do not appear to be missing any references. Obviously something is missing. Any thoughts?
Update (9/29/2006)DAO Language Reference (http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/office97/html/output/F1/D2/S5A25F.asp)
View 10 Replies
View Related
Dec 30, 2007
Does anyone know where the Compact and Repair feature is to be found in Access 2007? It was on the Tools menu in Access 2003, but I can't find it in 2007!
Thanks,
Gary
View 1 Replies
View Related
Jun 18, 2013
I'm currently working on a project which requires integration of sms feature in ms access 2013.
The sms provider which i use for sending sms is smsglobal.
View 1 Replies
View Related
Dec 12, 2005
I have built a rather extensive database using Access 2000. When I install it on an Access 2003-enabled machine, the first time it is opened, the user is presented with the following errorbox:
"An error occurred and this feature is no longer functioning properly. Would you like to repair this feature now?"
At this point, clicking "Yes" results in an update the installation of Access 2003. Then the database must be opened manually again. Then, the following is displayed:
"Module not found."
Closing the database at this point and then opening it again results in a normally functioning database.
I have several questions:
1) What is the feature that is no longer functioning properly?
2) What is updated when the installation exec runs?
3) What module is not found? I assume this is one of the VBA modules that I've created, but I've check all 62 of them and they all seem to be there available.
4) My first guess was a reference problem, but I've checked the references used and all are available, as far as I can tell. These are the ones that I have referenced: VBE6.DLL, MSACC9.OLB, DAO360.DLL, STDOLE2.TLB, MSCAL.OCX, MSADO25.TLB, MSO9.DLL.
5) After getting the first error - the one about nonfunctioning feature, I clicked "no" to the repair now question. This does nothing except the database remains open. At this point, I opened the code and tried to compile, but I get the "module not found error". I likewise tried to set a breakpoint in one of the first modules and I get the same result.
6) I even tried to copy the forms, queries, tables, and reports into a blank database with no references and no other extraneous code and received the same result.
This site has been extremely helpful in the past and I am really relying on you guys again for the same stupendous help now.
Forever in your debt,
Tom
View 5 Replies
View Related
Jan 13, 2005
I am trying to setup a webpage for people to update
access 2000 db using FP2000 and DRW. I do not want
update all fields in a record though - a couple of them
are static. I have been unable to do this. I am using
code lifted from another page and DB that does
exactly the same thing for the update. I either get the
error data type mismatch, or I should provide default
values for all form related fields, or no records get
updated.
Is there anyone who can point me inthe right direction?
Thanks,
Tim
View 2 Replies
View Related
Nov 27, 2006
Hi,
I was wondering if i could get some help here. I think this is to do with the security issue. I usually double-click to open or run an access file (for example student.mdb) that sits on the server with no problem. But this time, nothing happen when i did double-clicked on it from my laptop while the file was being open by someone'else on another computer. I know that it makes sense that we shouldn't open a file that's being used by other users. But my curiosity is that should it not give you a warning like (you know) you're not able to save any changes or things like that. No, i didnot get any of that messages. It's just nothing happen after trying to open it by double-clicking it.
I have set the macro security to low level but that did not help either. Is there any thing that i need to tweak?
Thank you in advance
View 2 Replies
View Related
Aug 21, 2007
Ok this is a weird issue that has been troubling me, On some computers that I have, Access refuses to open databases through a shortcut. The only way to open any databases is to first open access the go to file open.
I've tried creating new shortcuts, as well as mapping a drive and making a shortcut from there...but nothing is working. Is there a setting that access has to preven this? The same database can be opened on different computer without a hitch....
View 1 Replies
View Related
Oct 29, 2004
Hi,
I wonder if anyone can help me.
I have a form which has a links to a table of student ID's. I also have a project folder where images and documents are loaded into. These can be jpegs, bitmaps, gifs, office files (all types) etc
The files are named by the user and dropped into the folder. The name relates to the student ID. For example student: 3001 can have multiple files: 3001.jpg, 3001.doc, 3001.ppt etc.
When each record (student ID) is displayed on screen I need a list box (or something) to display the files associated with this student ID. Then, if possible, the user can double click on the file(s) to open them in the computers default program.
I'd be really grateful for any help on this one. It's got me baffled. I'm only a starter to VBA.
Thanx.
Chris Coleman
View 7 Replies
View Related
Oct 23, 2006
I'm trying to import about 18 excel spreadsheets into one database in Access. I've been using "get external data" to import the spreadsheets as tables, and the first 8 of them worked fine, but now I cannot import any more excel files. The only error message I'm getting is "An error occurred trying to import file 'C:....xls' The file was not imported." And this error pops up after I have gone through all of the importing steps. Did I exhaust Access's resources? It's not a format issue, and I've restarted, etc. I'm at a loss.
View 2 Replies
View Related
Jun 1, 2007
Howdy,
I am trying to clean up one field of a large database. Currently this field has many records that are listed as "XXXX, Inc.". I am trying to find a way to change all of those to "XXXX Inc" in the entire database.
I saw raskews code snippet on changing multiple characters in a string, but I have to admit I have only use VBA in Excel before and having a hard time with the basics.
Does anyone have some code or ideas on how to do this or something similar?
:confused:
Thanks,
Will
View 4 Replies
View Related
Feb 26, 2008
Edit:I just realised i had accidently writted the title as (to do with importing access data) it should read (to do with importing excel data)This is going to be a trick hard to understand question but I will try my best to explain itI have a database set out in the following wayhttp://img524.imageshack.us/img524/1350/databasetableli1.pngThe way it works is; Let's pretend Access Programmers is a company and working on different forums is a different jobSo on one record it would readJames.90| Access Programmers|Tables Forum| Wed=3= Mon=2Then the record below might readJames.90| Access programmers | Forms Forum| mon=5 tue=6So each record is one unique company,Project and CTR which the person has worked for that week meaning if you only work on one forum you would only write one record out each weekNow the data i am receiving is in an excel file where it's set out in a daily basis Where One Day Date|Name|Company|CTR|etcSo if a person works 5 days a week on 2 companies each day that is 10 records when it should only be 2 recordsSo to sum it up. My database is set out weekly and the excel data is set out dailyMy questionWhat would be the best way to convert this data into the database. Changing the database structure around is not an option and i can't change the format we recieve the excel data in. I can change it once i have the file thorough a converter but i can't change the raw source of the dataWhat would be a way to solve this problem because i am completly stummted and am open to any option of converting or anythingThankyou for your time. Also if you have trouble understanding what i mean Please say so and i will upload a copy of the database and a copy of the excel sheet!
View 10 Replies
View Related
Feb 16, 2005
Hello,
I have getting type conversion errors for numeric and currency fields when importing an Ecxel spreadsheet into a Table in Access. I have tried changing the data type to text in Excel, and that is what it says I have done when I examine the field formats in question. How can I force this to be text, it keeps reverting,
i.e. the fields in question, to numeric and currency. Can anyone help? Thank you.
Joe
View 4 Replies
View Related
Feb 23, 2006
I'm trying to establish a ticket/citation database for a college security office at which i work at. I have two tables, table 1 includes the ticket information (date of ticket, citation number, *tag #, amount etc.), table 2 includes Repeted offenders information such as (name, address, city, zip, phone number, student ID# etc.).
I would like to have a table or query(preferably table) which automatically matches tag#'s to student information as soon as a new ticket is entered, *if the student information is available.
Thanks a lot in advance
View 3 Replies
View Related
Jan 31, 2006
Hi, I want my user to be able to "cancel" his entry. At first I tried just deleting the record they were working on. But that added numbers in the auto number "ID" field, and I also needed the feature for editing, so deleting wasn't an option. As of now I have something that works, but is kind of messy. I made a mirror "temp table" that I write the record to. If they "save" i append/update the record to the regular table, then delete it from the temp, if they "cancel" I just Delete it from the temp. Was wondering if there was a cleaner way to do this ?
View 5 Replies
View Related
Oct 12, 2006
Hi
After looking through the forums, i couldn' really see the answer i was looking for.
I have a form, that users can enter in details (with an auto-number created which is assigned to each record). Once they have entered the detials, theres a 'save' button which will save the record - which is fine. I also have a 'return' button which should return to the previous form and doesnt save the record. But as it stands, the record is saved when i click this return button. How do i make it so that the record isnt saved untill the save button is clicked? so if i return from the screen (pressing the return button), the record isnt saved (i.e. a cancel button).
Thanks in advance :)
View 4 Replies
View Related
Jan 1, 2015
I would like to add a zoom feature to a form. If I size the window down to the point where it cuts off some of the fields, I enabled the vertical and horizontal scroll bars for the user to navigate throughout the form to see everything they need to. However, is there a way to size the contents in the form down, in other words, zoom out so even if I size the window down, I can see everything in the now smaller window?
View 6 Replies
View Related
Sep 12, 2005
Hey all, I have a strange problem that I can't seem to find the solution for...
At my work we have a number of computers running W2k with Office 97.
We daily have to import excel spreadsheets into Access.
This is never usually a problem as obviously as soon as you click import the import spreadsheet wizard appears.
But on one particular machine it doesn't.
Basically on this computer Access will import the excel file, but won't bring up the wizard that lets you say what to import, whether the first row contains a header, the data type for each field etc, it just asks you to select what sheet you want, then imports it, no options.
Now the ironic thing is that usually this is not a problem as the file is still imported without any problems, but the other day we had a file that once imported was all messed up, all fields all over the place.
When done again on a different computer there were no problems so I'm assuming that this peculiar way of importing is to blame for messing up the data.
Does anyone know how I can resolve this? I have tried dragging the accwiz.dll over the regsvr32.exe and it says it's registered successfully, and I have checked that it is the correct version number, what am I missing?
It would make more sense if it just didn't import, then you could better understand how to fix it, but it's the fact that it does import, just not in the 'usual' way that bothers me. How can I make it bring up the proper import spreadsheet wizard?
Kind Regards
rd_boon
View 1 Replies
View Related
Dec 20, 2006
I need to implement a Quick search feature in my employee application.
So that when any text is typed into the textbox, it searches the db for a match:
e.g.
firstname
lastname
ss#
employeeId
deptId
officelocation
deptname
It returns the record in the employee table that consist of the text typed in the search box. Most websites have this quick search feature (blanket search..is that what it's called?) and a link for advanced search, where they can select specific fields to search.
View 4 Replies
View Related
Mar 24, 2007
I was trying to incorporate the changes suggested by a member of this forum into my Form. I opened the Form in Design View. I clicked the Command Button and placed the mouse at the insertion point. The command button also appeared. Thereafter, nothing happened. Earlier, whenever I placed a command button, it asked for action to be performed in relation to that command button. But now nothing happens and I don't know what to do. Please tell me how I can bring back the feature.
Thanks.
View 2 Replies
View Related
Jan 22, 2014
i have created a database and just use the feature to split the database. i then set a password on the back end database. however now when i use a macro to open a form in the front end it won't open the form and just says incorrect password.
View 1 Replies
View Related
Nov 10, 2014
I am in the process of trying to create a DragNDrop feature in the Access database that I've built. I have 3 employee with several different txt boxes all side by side and I need to be able to drag and drop the job from one to another.
I need to create a class module to do this but my problem is I don't know how.
View 7 Replies
View Related
Feb 20, 2013
Any way to "work-off-line" in a split database, and then sync the data when one is done working?
View 9 Replies
View Related
Aug 13, 2014
I have a web database that I am trying to create a search feature for just 2 of the fields. The search is for a certain date and also a shop are the 2 fields I would like to have the search run for.
Once the search has been run I would like to generate it into a report.
I have already created the report/ form and the query. I am not sure where I need to go from here. I have created the from with the date and also a combo box for the list of the shops and then a button that says search that will go to the report. I just need it to show all the particular items that show the date and or shop. If you leave them both blank it will run a report and show everything. Then if you just put a date in it will run a report with just that date or the same with the shop.
View 9 Replies
View Related
Nov 20, 2013
I have a subform containing maintenance logs for pieces of equipment, viewed as a Datasheet.
I have a field called Comment accepting text. Since comments are similar, it would be nice to have a drop down list so the user can select what was previously typed in other records and then edit it from there, similar to how Google or search engines in its search text box generates as part of its suggestion list the previous searches after typing in the first few matching characters.
I tried looking through, but is there a property that does this?
View 3 Replies
View Related
Feb 26, 2014
I'm working with a DB to enter orders for picking. I have an item list that I'm linking to when entering orders, and bringing in the data from the item list such as item location etc.
It's setup right now that when I type the first couple of letters into the item field it automatically brings up the matching items and if I click enter it completes the item and brings in the other fields from the item list.
Example: If I type in 'tom' I get back 'tomato', 'tomato sauce' etc. and when I choose the right one and hit enter it fills up the rest of the required info such as item location.
What I would like it to do is have the auto complete also check for middle words.
Example: when I type 'alm' it returns 'almonds', 'almond milk', but don't return 'container almonds' or 'container roasted almonds' etc.
View 1 Replies
View Related
