Search results

Hi Guys, I'm putting together a database and have pinched a search form from an old database I created. I have changed all the relative references to the new databases fields... ...However... Whilst I can get the list box to populate off the query, I cannot get the search itself to work...

ah, ok I think I understand what you're saying, not sure how to fix it but i'll have a play and try and figure it out! :) I'll have to go down the subform route as it needs to be one 'form' as such as it will be used for quick access information, updating and entry. I can think of a quick fix...

I had full records entered, and saved, and then re-opened the form and it was not showing any records....

Hi All, I had an issue the other day that had a simple fix, since then I have cleared the data out of the database and started testing it to check its usability. I entered in a full record, and flicked back and forth between the records, and everything was looking good. Then I closed the...

Oh, you are kidding me, I missed THAT? :banghead: Thankyou very much!

Hi, I'm fairly new to databases and have been attempting to build a multi-table database. It's not properly rationalised, but I wanted to test run it to ensure it was fit for purpose first. I've built my form, which is pushing data out to several tables, but I cannot seem to get the form to...

I'll do my best but obviously as i'm doing this for someone else it may not come back straight away! thanks for the help so far - I've read something about UTF-8 encoding which seems to features the whole ü converts to ¼ thing so i'm trying to read up on it as well! thanks for your help so far!

I've asked the question and am awaiting an answer - if i can get a example of the file with the erronous characters - would that help?

ok, I'll get them to give that a try - I don't suppose in the meantime there are any lists as to what actually means what - I have half a dozen bits here's a I need to convert or find and Germany is a really big place :eek: @ DCrake - Same font - translator not needed as they are typed into the...

All I know is that when we receive the excel files, they are already like this, however, the person who is sending them is swearing down that they are in proper formatted german (hence why we have no real editorial rights). From what i've read up on it could be some sort of import error or...

Hi, I'm hoping that someone can point me in the right direction of a listing to do with German Characters. We have daily excel files that come in and often the special characters ( Ü ö ß etc) often come in converted to things like ¼ æ ¥ instead. This obviously then takes us time to attempt...

ah I see! that makes sense now - it's probably the joins but atleast i know what part to look at! now why can't there be books out there that explain things like that - everything seems to be full of terminology and stuff thats just too weird to understand! Write a book dude - i'd buy it!

between the both of us apparently we can't get our words out right! ah... so i'm multi layering them then? just out of interest.. is there a limit on how much you can do with layering - just interested because I tried writing a query earlier and got a message of "query is too complex" or...

ok i'm confused now - i'm dealing strictly with the query - forget the report, that i will sort - and sorry i didnt mean black - i meant blank! ie. its not bringing up a value at all. I'm really confused as to why its doing this!

I'm probably going to sound really stupid asking this but; I have a select query in which the individual componants are all total sum'ing the records from the tables. However - how can I sum up the summed values. If I try writing an expressions (ie. [sumofPUBPST] + [sumofPUBTEL]) it refuses...

brilliant stuff - thank you very very much! :)

I may not be right here.. but here's my shot at it. If you create a basic select query - which will bring up all the data from your table - and then use a date ascending / decending under the date field of your table within the query, this should filter (sort) it correctly. If you base your...

hi guys, probably a stupid question, but i have a series of number fields on a form, which are all defaulted to 0 (through the table for consistancy's sake). however, when i test the form, you have to wipe the 0 out before entering the figures required. is there any way of having the default...

yep, that would make much more sense! curse the dodgy CAB on the wall thats making all the noise and sending me doolally! thank you muchly for the help!

Hi guys, I'm a bit of a novice at this so bare with me. I've written a little expression for converting a number to text for a report. There's two stages to this, I want the 1 to be converted to "PUBLIC" and the 2 to "NON PUBLIC". If i test these two separately, they work fine, but if I...