Is there a way to prevent Access from "auto-correcting" certain characters?
Example: If I enter "DEJA VU" into a table Access changes it to "DÉJÀ VU" with the strange É and À characters. I don't want this to happen.
There must be a way around it.
Thanks for your help.
I have been working on a a table design, but I am failing to create the correct relationships.My main table is the tblIncident with the three remaining tables being linked via a one to many relationship. I am using an auto number as my primary key, then linking that number to a FK in each table.
The end goal is to create one form with a varying sample of combo boxes, check boxes and data entry fields from each table. I did not plan to create a subform for each table, but maybe that is required?
I have a table called 'students' with the appropriate fields. There is another table named parents_prof which contains records of common professions. The tables are related through the 'ID_parents_prof' of the 'parents_prof' table to two fields on the table 'students', thus 'students.father_prof' and 'students.mother_prof'.
1st question) Is that possible? Is it possible to create a relation between the key field of one table to two different fields of another table? Is it a good practice?
I did this because I want to build a query which checks for both fields together, meaning I want Access to return a record if the appropriate profession is in either field of mother's or father's profession.
SELECT students.surname, students.name, students.father_name, students.father_prof, students.mother_name, students.mother_prof
FROM parents_prof INNER JOIN students ON (parents_prof.ID_parents_prof = students.mother_prof) OR (parents_prof.ID_parents_prof = students.father_prof)
GROUP BY students.surname, students.name, students.father_prof, students.mother_prof, parents_prof.parents_prof
HAVING (((parents_prof.parents_prof) Like "*" & [enter profession] & "*"));
Access cannot represent the above graphical, so I had to enter the
OR (parents_prof.ID_parents_prof = students.father_prof)
in the SQL formula.
2nd question) Is the above proper query, according to the rules?
Hey guys,
having a problem with a query, its used to export data to a txt file for another program.
the problem is i have a field that i format with end of line chars between entries in the field, so in access it looks like a few entries rather than one field (there were reasons for this).
when it comes to export this data, i need to remove the end of line chars with spaces.
heres the part of the query i need to fix:
Description: IIf(InStr([Order_data].[Stock2],Chr(13)),Replace([Order_data].[Stock2],Chr(13),Chr(32)) & Replace([Order_data].[Stock2],Chr(10),Chr(32)),[Order_data].[Stock2] & " " & IIf(nz([Order_data].[Stock3])<>"",IIf(InStr([Order_data].[Stock3],Chr(13)),Replace([Order_data].[Stock3],Chr(13),Chr(32)) & Replace([Order_data].[Stock3],Chr(10),Chr(32)),[Order_data].[stock3]),""))
yes that is nasty.. but simple to understand. 2 fields get combined for output (stock2 and stock3), i check first if they need to have chars replaced, then replace if necessary. the output i get though doesnt seem to be replacing the chars, it finds them there with the if however.
any help?
thanks guys
Hello,
I had a custom application created for me. Yesterday I received the compiled build to test. It worked fine.
For some reason, today I cannot run it. I get an error that says: "Connect to server, no such host is known".
My programmer is stumped. Do you have any ideas?
Thanks so much
What is the maximum no. of characters allowed in a combobox?
View 5 Replies View Relatedhi there,
im working on a project for the boss but i've come across a couple of problems
first, i'd like to know if there is a way i could search for a specific string of characters inside a field, for example, search for a 'malouf' in the name field (without having to reclassify my fields separately as first name and last name). i've tried the LIKE command, but it doesnt work the way i'd like it to.
And other question, i would like to create a validation rule for a field in an entity, but it is based on whether or not a record was in a query result. specifically, my validation rule is that i cannot put in a particular TruckName in the Truck entity if in my query "Unavailable trucks", that particular TruckName is listed there. Ive tried so many IIF commands but i dont really know what to do.
thanks a lot guys!
TextBox1 has, of course, a maximum of 255 Chars.
I imagine Unbound TextBox2 will count down from 255 with each keystroke entered to TextBox1 so I know when my limit is getting close.
Hi all
I'm working in Access 2000 for the first time and all was well until I introduced a wizard-created Switchboard. I created the Order Entry database using the Access wizard and copied the Switchboard form and tables into my database.
Since then I keep getting the following message:
"Error accessing file. Network connection may have been lost."
I've Compacted and Repaired but still keep getting the message. Does anyone have any ideas what's going on?
tia
shay
I have done some forms and it is the first time that i had this problem:
I can input data in several records without having any problem but when i close and save the form and next time i open it ,i do not find my previous records. I checked this in the tables and find that the values that i had input were there but in my form these values had disappeared. Can anyone explai this ..
Also,
Suppose i have 2 tables with NAME set as the primary key and which is linked 1-1. When i create a form for these 2 tables and when i write JO in the name field only once the name JO should automatically be inserted in the other name field i.e i should be able to input only one data. This is not the case. What i should do is : write JO then click in the other NAME field then type something e.g RO then this will be typed auto. in the other Field. Can you also explain this
I have a form with a tab control and each tab has a subform on it. 3 of these tabs/sub forms are continuous forms that allow the user to enter details for the selected job (i.e. on tab has a subform that allows the user to enter various scheduling dates for the job).
If I say have the scheduling tab selected and then change a field in the MAIN form, then click on the new record row in my continuous subform my main form jumps to the first record. However, if I update a field in the main form, select a different tab, then click on the new record row in my subform it works fine. Also, if I click the add record button it works fine as well.
I can't seem to find anything in my code that would cause the jump. Any ideas?
Thanks,
Hammy
I received a very strange error this morning.
I was going to create a new query with the simple query wizard, but as soon as selected a data source I got a message saying "The expression on Got Focus you entered as the event property setting produced the following error: The text you entered isn't an item in the list."
After this I can select a datasource, but the cursor remains in hourglass mode. It almost seems like this is a run-time error, when I am merely trying to create a new query. In addition to which, I haven't set any events to run on "got focus". Anyone have any ideas on what is causing this and how it can be fixed?
Thanks,
Chris
Hello,
I have a strange problem which have to be solved in Access in all way, if it is possible. :-) I have to create a table similar to an Excell sheet. Row headings are name of persons, column headings are workplaces. The aim of this table is to register worked hours at each workplaces per persons. At one person in one shift more workplaces are possible. The number of persons and workplaces is changeable. Does anyone know how could I solve that to store in different records each workhours? For example if a person works 4 hours at 1. workplace and then 4 hours at 2. workplace, this would mean only one row on the form, but two records in the table.
I would be very grateful if somebody would have a good idea! Many thanks in advance!
VoiD
I was working on the design of a form and had just made, what I thought, were some fairly minor changes. The specifics of which I can't recall. On saving the changes and attempting to go back to the form view I got a pop up window with the following header;
Microsoft Office Access has encountered a problem and needs to close. We are sorry for the inconvenience.
I can either send and error report or choose not to :rolleyes:
The up shot of all this is everything else in the DB seems to still work fine, but I can not open the effected form in either design or form view without Access shutting down :mad:
Has anyone seen anything similar? and if so any idea what may have cause this dummy spit? and Is there any way around this without deleting the effected form and rewriting it?
Hi to all,
Here is my problem:
I import value from an excel sheet and write them in a table, i use Excel object reading cells row by row. All works fine but after 1900 or 2000 rows program hangs without errors if i place a stop in program when my row counter reachs 1900 and run the program step by step that works, i tried to place a sleep command each 500 rows without better result. Does somebody have any idea ?
(i use Office 2000).
I can't use transferspreadsheet because for any reason in my excel table generated i have #Number! errors in some fields and i don't know how to skip these records.
Thanks in advance for help.
VINCENT
Hi All
I have just noticed some strange behaviour in access. I hava and asp page which gets two dates which are then used in a sql statement to refresh a page. The end of the statement deals with a between clause like this
WHERE tbl_Movements.date_of_Movement Between #12/03/2007# AND #30/03/2007#
But when I view this in design mode it changes it to
Between #03/12/2007# And #30/03/2007#
Why does it do this and what can I do to resolve it
Thanks
Hello To All,
Has anyone seen the message in the attached file? I got this when I was trying to update the row source on the field after I had a problem with data in a report coming up inaccurate. I've been developing in MS Access for about 7 years now and have never seen this. Any explination for this would be greatly appreciated.
I am using MS Access 2000 on a Windows 98SE machine. :eek:
- Charles Williams
Hi,
I have a query that in some cases it works and in others no. I've tried :confused: everything :confused:.
The problem is very strange: attached there is the database!
Anybody have any idea?
Thanks!
P.S.: :) forgive me but I don't write well the English!
It may be a simple problem I don't know. I have to do an inventory control database in Access for my Systems Design paper however I am having an issue with queries.
I have a query called Item Status Check and it asks the user for the item code and goes in a table called Inventory Item to get the results. Now the problem is after I added a whole lot of new items (I had some from testing earlier) it does not bring them up in the query at all, its ignoring them basically.
Now I find this strange because other queries like suppliers etc still work fine and access any new data I put in.
I know its going to be simple but its doing my head in.
EDIT: Found more.
The ISC query has the following field
ITemID
ITemName
SupplierID
CarryCost
RetaiPrice
StockMin
StockMax
StockOnHand <--- from a stock on hand query.
Now if I delete the stockonhand it shows all the stock so thats the problem. The way I have calculated stock on hand is to simply take all the purchase orders, add them together and subtract the customer/production order numbers. I don't know why this would happen
EDIT 2
found the problem, need the solution
In the StockOnHand calculation is takes all the number of incoming stock and subtracts the outgoing stock to get its answers. If the stock isn't on one of each of the incoming/outgoing forms it doesn't show it at all.
EG
Incoming Stock:
Purchase Orders
Add Stock (from an alter stock form for discrepencies)
Outgoing Stock:
Customer and Production Orders
Remove Stock (alter stock form)
If items have not been used on 1 of each of these they don't show up in queries with StockOnHand.
Thanks in advance
Hello all. Have a bit of a strange one here (and fairly frustarting). I have a table which includes a field (type memo) which holds text comments.
I have a query which includes this field. For some reason, when the comments field is empty (identified thorugh opening the table), when it is returned through the query is shows two characters, namely '@v'.
Can anyone shed any light on this for me? Thanks for reading :)
I have a select querey
which contains the expresion
forms!frm_itemslct!text8
It should just pick up the value contained within [Text8] which is a number, and it was doing that earlier this evening. I've since changed something and instead of a number it is now showing a small square :confused: For the life of me I can't work out what it is that is causing this.
Hi,
The Problem that im getting is that when I query select a yes/no field in a table the results return TRUE and FALSE, even when the criteria states Yes.
does anyone know whats going on with it.
I know it isnt me as I have had my collegues check it over and they are all confused as well.
any help will be great!
i have a form with some control on it. Among these controls, i have 2 unbound image control, which displays linked images.
Now i am noticing that with this particular form only, if i start click the next record arrow in the navigational pane very fast to move through the records, all of a sudden the whole access database will disappear abruptly leaving .ldb file open.
Any idea why this happens ? Do you think that those 2 unbound image controls has to do with it, because if i try hitting the next record button extremely fast in other forms, it simply scrolls through the records, without the closing the database abruptly.
Thanks!
Many will look at this and laugh but its real.
My Access Dbs are opened in hidden state and i dont see my forms.
This must be the cause.
I tried to hide the menubars using ghudsons code,i disabled the shift key. But i dont know what has happened.
I can nolonger view them. I have tried every method out and i think the only option is to repair OS, may be it will work.
I have enabled the database which i disabled the shift key but when i hold down the shift key, it loads but the forms are totally hidden, STRANGE! ijust see the grey access background and when i click on it twice from the task bar.It pops up.
I have tried to make another database, use the autoexec macro to call a form which enables all command bars, but this works only for this database and when i press the shift key down, this database hides the toolbars and i only see the grey access background. This is happening on EVERY DB ive developed on this machine. I thought it was the access that is totally corrupted but i tried to reinstall my office and i still get the same results
This is now a NIGHTMARE to me.
When db is shifted to another machine it works fine as before.
This is REAL but can i get some suggestions from you folks before i repair my OS.
Hello,
I am trying to add a normal JPEG image to an Access 2003 form through the "Image" control.
The problem is that when I browse for images , it does not show any JPEG images, but only BMP and images of other 3-4 formats - The JPEG format doesn't exist there. When I try to add a JPEG through "all-files" it gives me an error message - "does not support this format".
There is not problem viewing JPEG images on WinWord or other programs.
Has anyone heard of such a problem and its solution?
Thank you
Gabi
I am trying to use the runsql command and I am encountering a strange problem.
The following works:
DoCmd.RunSQL ("INSERT INTO financial VALUES ('" & clientNumber & "', " & txtFinancial & ", '" & firstname & "', '" & surname & "', '" & txtDate & "', '" & txtTime & "', '" & editdate & "', '" & edittime & "', Null, Null, Null, '12', 'Bob', 10)")
But when I change the Null to a textbox with a null in it, it wont work:
DoCmd.RunSQL ("INSERT INTO financial VALUES ('" & clientNumber & "', " & txtFinancial & ", '" & firstname & "', '" & surname & "', '" & txtDate & "', '" & txtTime & "', '" & editdate & "', '" & edittime & "', '" & txtacc & "', Null, Null, '12', 'Bob', 10)")
The textbox txtacc has a null value in it.
This is frustrating me beyond belief. Please help.
Thank you in advance