Is there a way to prevent special characters from being converted into symbols when copying and pasting text into a textbox control on a form?
For example:
If I copy and paste the below bullet item into my textbox, Access will convert the bullet into some weird symbol. How can I fix that?
. SET Key #12, #13 and #14
In working with a database, I need to convert 39,000 text fields (i.e.: 6002.2 , 2723 , 6004.55 (Notice the spaces)(commas denote next line)) to number fields. The number of spaces is random, so I can't say "cut off the last n number of characters." There may also be characters that I'm not seeing. I'm not too keen on going through it by hand, and I have access to OpenOffice.org Calc (for those who don't know, it's basically a free version of Excel) so I can pull it into there and convert it, but it still won't get rid of the spaces though. Any ideas?
View 13 Replies View RelatedI have a value that I need to enter into my table. The value is : 12(4B)(5)(c) but when I enter that value the "(c)" converts to the copyright symbol ©. How do I enter that value without it converting to a symbol.
View 3 Replies View RelatedI am on Access 2000. I would like to know how could I define the number of symbols that can be input in a certain field? For example in Home Phone field I would like to be able input more than 30 characters, but database doesn’t let me input more than 16. How can I change that?
Thanks a lot.
Regards.
When I add ANY record to a Table I get meaningless symbols in a Text Field on my Report.I have a Microsoft Access Database of College Football Teams and their Schedules that otherwise works just fine. In the past, I regularly added new teams to the Teams Table. I enter Team Name, Conference and Division affiliation (if any), whether or not they play home games on Grass or Turf and a hyperlink to the team's website.
I went to add Fordham to my Teams Table, as Fordham plays at Temple this week. After I entered the information in the Table, I saved and ran the Compact and Repair Database tool. I went to run a Report that contains a text field called "Comments" that I enter non-indexed comments about the game manually in the Schedule Table or on a Form. Not all games have comments. However, as a result of entering Fordham in the Teams Table, I now get nothing but weird looking symbols that look like Wing-Dings or Chinese Script in the Comments column on the report. These symbols show up in each row under Comments, whether or not I actually have a comment in the field. These symbols also show up on the report no matter what team or time period I select on the Form that runs a Query that generates the Report.
I isolated the problem to this addition of Fordham, because if I delete the Fordham record from the Teams Table, Save and Compact and Repair the Database, I can return to the normal looking text in the Comments Text Field in the Report. I tried only entering "Fordham" as the team name, disregarding any of the other information, like Conference, Division, playing surface or (most importantly) the hyperlink, but I get the same symbols. I also tried entering just a team name of something other than Fordham, but the same pesky symbols show up. I restored a previous version of this database before the problem showed up, but, when I added Fordham, I got the same result. I tried searching on this topic, but with little luck. There were a few things like making sure the hyperlink was not indexed or Unicode Compression was off, but nothing really more than that.
I read somewhere that I could right click on a form that I designed and convert it to a report. However, I have yet to figure that out. I don't have that menu option when I right click on it. Is there another way to do this so that I don't have to duplicate effort here?
View 8 Replies View RelatedI have a txt box on a form in which I type the month of the year e.g January, February etc. What I am having problems with is in another field I need to convert this month to it's corresponding value e.g. January will be 1, February will be 2 and so on.
View 14 Replies View RelatedWe recently updated to 64 bit Office 2010, however there is a form created by an intern who has since moved on, anyways the form was created in 32 bit. SO hence we cannot open it. We get any error message that it was created in 32 bit and cannot be open in 64 bit Office. I have tried to resaved the form on a different pc with 64 bit office. But it will not allow me to save, possibly because the form is locked down from changes. The file extension is .accde.
View 1 Replies View RelatedI run duplicate check on a form to make sure the file name doesn't match one that's previously been entered. Currently I have:
If Me.NewRecord Then
If Not IsNull(DLookup("File", "tblFileProcessing", "[File]=""" _
& Me![File] & """" & " and [FileClientID] = " & Me![FileClientID])) Then
DoCmd.OpenForm "frmDuplicateFiles", acNormal, , , , acDialog
End If
End If
However we've recently changed the way we work and have now added a unique ID number prefixed to the file name: 567_File_Name_1 How do I run the DLook up but parse off the digits prior to the first underscore and only check on the remainder of the file name?
In my database there is one value that requires the use of a /. (This is not as a name of anything...just a value stored in one of the fields.) I have a form which functions beautifully in all other regards, but it produces an error about syntax of the subquery in the expression if I try to use this value as a criteria for a search/filter (screen shot of error message attached).
I've tried using double quotes and square brackets around the / and a in front of it to no avail. I don't have the option of changing the value...it is defined by this multi-billion dollar project. Again, this is just a piece of data in a field in a record which also needs to be a criteria in some searches/filters.
I have Access db's that were originally created in Access 2003, I have upgraded them no problem to accdb and am using them in Access 2010.
When I create a new form and add a button it is rounded/shaded/white/blue etc - looks good.
When I add a button to an existing form, or reformat the existing form buttons (back colour Accent 1, Lighter 40%, Use Theme Yes etc) it remains an old style button (unrounded, solid colour etc).
How to convert old style buttons to new style buttons ..
I have a table with a huge master list (some hundred thousand) of unique bar code tags, which either have 8 or 12 digits. (Valid characters are "012 345 678 9ACEFHJKLMNPRYXW"). I created a form, which is automatically looking up valid records as the string is entered position by position from left to right. This is working fine and sufficient in 99% of the cases.
Sometimes characters are not readable on the original document, so I need a tool/form, were I can enter only the readable positions of the code and the tag list is then filtered accordingly. For that, I created a separate form with 12 text boxes for each possible position of the bar code and a listbox. This list box should be filtered as the readable characters are entered in their respective positions/textbox.
Is there a way to increase the maximum characters allowed in an expression of a macro setvalue action ?
I have an expression in a macro setvalue action that adds multiple form textbox values. I need to change the form name from "RATING ENGINE 2" to "E RATING ENGINE 2". When I do this, I exceed the maximum characters allowed in the expression. Is there a way I can rename "RATING ENGINE 2" without this problem. The expression is as follows:
[Forms]![RATING ENGINE 2]![Excess Liab Premium 6]+[Forms]![RATING ENGINE 2]![Excess Liab Premium 7]+[Forms]![RATING ENGINE 2]![Excess Liab Premium 8]+[Forms]![RATING ENGINE 2]![Excess Liab Premium 9]+[Forms]![RATING ENGINE 2]![Excess Liab Premium 10]
I saved my database as ACCDE file which is executable now the problem i am facing is i can't edit my database since i can not view it into design view.
How can i change it to its normal file format
I have created a database but I would like it to be an exe. is this possible? if so, how???
I would like to lock the design and the code for the database. I will be holding about 2000 entries, will this be a problem?
thanks
Hello Everyone,
First of all thanks alot for investing your valuable time in reading my query, I wonder if someone can kindly educate me on how to convert an access database.mdb file to an executable .exe file. Also is there a way to create an installation package to install the database to many Computers.
Thanks Again
Warm Regards,
Darno
hi guys!
i just wanted to find out how do i convert an mdf to access,
please help!
Kind Regards
phindile
I have a dbase that was created in access XP. We are in the process of upgrading to office 2003. For the most part the database works fine. However, I have 1 form that has a few fields that have conditional formatting
on them and when the form opens those fields flash very fast continuously all most like the tab key is being held down. No matter what I do I can't get it to stop. Has anyone seen anything like this and how do I make it stop?
jon
This is the error i get...
This error is usually associated with compiling a large database into an MDE file.* Due to the method used to compile the database, a considerable number of TableID references are created for each table.* The Microsoft Jet database engine version 4.0 can only create a maximum of 2048 open TableIDs at one time.* Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).
There is no accurate method to estimate the number of TableIDs the Jet database engine uses during the process of compiling a database as an MDE.* However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used.
More information about this error message online.
My database is by no means big, is there any other way i can convert from mdb to mde?
Thanks
Den
Hi All
A simple problem no doubt!
I am trying to convert my Works database into an Access dB (which I have just bought). I cannot find any help on this anywhere?
Any help will be much appreciated
Thanks
Paul
Hi.
For years several agencies have used a database written and maintained in Access 97.
One adminstartor has both 97 and 200 on his computer and no problem. Until now, that is.
When I try copying a revised front end, and opening it, I get 'unrecogized database format' message.
My hunch i sthat said administartor accidentally opned the basck end with 2000 and converted it.
So, can the back end be unconveted/reverted back to 97?
Any other suggestions?
Russ
I have a problem converting access 97 mdb files into access 2000. There are multiple access databases that use a mdw workgroup on a network drive. I do have the ability to log on as an admin. Access 2000 is not letting me convert the files to the new format (telling me I don't have permission). The databases do have lots of forms, queries, macros and such.
Would the easiest method be to remove the userlevel security or is it possible to get around that? If I were to remove the user level security is it as simple as loggin in as admin, deleting all user account, granting all permissions to users and admin and removing the password?
Any help is much appreciated.
Hi All
I am currently compiling an Access DB to manage my work in progress, Payments due etc.
The DB is starting to work well and have requests from fellow contractors to purchase a copy (there are over 400 subcontractors in the group), with this in mind I have decided that when I complete the DB I will take it to a proffessional programmer and have it converted to a fully standalone programm.
My question: Is there a programm format that is preferable or would C# be the best option or is there a product out there that I could purchase and use.
Thanks in Advance
GeoffK
I've read alot on this, Tony Toews, Allen Browne and our own experts have put out lots of info.
I've started converting my dog straying database and have a weird result. This is split into front and back ends.
Result:
My PC Win XP Access 97 and 2003 works perfectly
PC 2 Win 2K Aceess 2003 ditto
PC 3 Win XP Access 97 and 2003
setup looks identical to mine no missing refeneces etc - No images will display in the image frame on the main form.
I have no hair left. Any ideas??
Hello,
I'm trying to get a way to creat a database of my phone messages (SMS).
I have them on a .txt file and I would like to create on ACCESS (or other program) the fields "Date:" "From:" "Message:", etc.
So, everytime I introduce a day, all sms sended on that day appears, or, when I introduce a Name, every message from that person, appear.
Is that possible? Of course that I want to convert it, not introduce one bye one because I have around 2000 messages...
Thank you very much
This is a example of the .txt file I have:
================================================== =========
Message type: SMS
From: 0: Maria
Date: quinta-feira 03 Maio 2007 15:33
-----------------------------------------------------------
Hum que bom então. Tou com a minha amiga na praça da república. Vais ficar aí?
================================================== =========
================================================== =========
Message type: SMS
From: Figueiredo 0: Maria
Date: quinta-feira 03 Maio 2007 14:59
-----------------------------------------------------------
Tas em casa?a mariana foi aí?
================================================== =========
================================================== =========
Message type: SMS
From: Figueiredo 0: Maria
Date: quinta-feira 03 Maio 2007 14:52
-----------------------------------------------------------
Já tá?
================================================== =========
================================================== =========
Message type: SMS
From: 0: Maria
Date: quinta-feira 03 Maio 2007 12:47
-----------------------------------------------------------
Desce tou no carro em frente ao mc donalds..
================================================== =========
I have time sheets from the past I need to enter but have found that some years the time punch minutes are given as if an hour equals 100 minutes not 60. Other years the minutes are given correctly. How do I format this field so that if I type 3.75 it will convert to 3.45 hours? Will I have to add another field to enter this and then convert to my field where hours and minutes are correctly entered? :confused:
View 2 Replies View Related