Search results

I'm fairly sure it's not the regional settings. It's only the one record. All the other records (before and after) are fine and we've not changed any PC settings. I've also checked it on my pc and I get the same nonsense. The regional settings are set to uk as they always have been.

One of my database users set up a new record a few days ago, entered all the information etc. He's now gone to have a look at it and it appears to have been translated into Chinese or something! The text fields have changed to things similar to 潩の＀ㇾ′敆湲慤敬, the autonumber field has changed to...

What version of access are you using?

Do you have any existing tables? If not, maybe that's why the existing table option is greyed out?

Try basing your report on a query that joins the tables, then you will have groupname available to use as a controlsource on your report.

Have a look in table design view (like your first screenshot) and select the field in question and check what you've got in the Field Size propery.

We already use Netilla for accessing our main office systems from home, but my understanding of these systems is that they all the processing is done on the server and all that is sent is an image of what would be on the screen? If that is the case, then this would not be suitable for using over...

Thanks for your pointers. I think I'm going to take a look at the ASP route when I get some time.

We are shortly going to start using tablet PCs over a GPRS bearer circuit for some of our employees to update our core business system from within customers homes. To do this we have purchased a very streamlined version of our core system, designed to work at a reasonable speed even over a...

I think you might be able to refine your query by putting in a range of values instead of the spaces. i.e. something like "*[ ,.]" & "Father" & "[ ,.]*", "*[ ,.]" & "Son" & "[ ,.]*" The idea of the square brackets is that it will return a match if it finds one of the characters within the...

This however might not pick up every instance of those words as it will only pick them up when they come directly before and after a space. If there are instances where they might be followed by a comma or full stop (or period for our American friends) then they won't be picked up as it is...

OK, German is not my strong point but I'll have a go. :) If you want to use the value in a textbox/combobox etc as criteria for a query, you just need to refer to the textbox/combobox in your query. (Okay ist Deutscher nicht mein starker Punkt, aber ich werde ein Gehen haben. :) Wenn Sie...

OK, problem not quite solved. As well as some notes containing apostrophes ('), it seems some notes also have speech marks (") as I discovered last night after running this code for a good couple of hours to convert my notes. :( Any ideas how I can cope with speech marks as well?

Problem solved, I hope. I just replaced '" & strNote & "' with """ & strNote & """ in the SQL. Is there anything I should be aware of in terms of problems created by doing this?

Thanks Wayne, that seems to be doing what I wanted. :) I am now running into problems however with notes that have apostrophe's in them. I get a runtime error '3075' (missing operator). I can only guess that it is treating the apostrophe within the text field as part of the code. I will search...

I think this might be what I remembered seeing.

Scott, it looks as though you may have been right about EMP's tone. EMP, these forums are all about helping each other out. There's no place here for having a go at people for helping. Scott's solution was essentially correct apart from the m/n typo. If you see solutions posted that may be...

No probs Scott. Easy mistake to make, I had to check the help file for the correct interval code myself. "n" doesn't seem the logical choice. I would have thought "mm" for month and "m" for minute might be more logical, but I guess the guys at MS have probably got their reasons. :rolleyes: I...

One approach, possibly not the best one, would be to create a query to base your form on. If you always want to search through all 4 of those fields, then add a calculated field to your query that puts together (concatenates) the values for all those fields so that you only need to apply your...

You need "n" instead of "m". You can check the different intervals available in help, but "m" is months, "n" is minutes.