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...

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...

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...

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...

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...

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...

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...

Hi Guys, This is probably a really stupid question, but I can't seem to find any information about it on the web, I'm attempting to design a report of which there a multiple queries as its recordsource, but I keep getting this error; Help!

Hi Guys, I could do with a little help in sorting the correct design for a database i have to build. I'm in a bit of a rush with it, and only have a few days to get it all sorted, so all information would help. I need to create, what we will term, an ORDER COUNT. Basically, batched orders...

Hey all, I’m probably asking a really stupid question, I’m a little lost and out of ideas at the moment. I want to create a control centre of sorts to overview 3 databases live where i can see who is in them, whether new records have been added, possibly how long they have been in them and...

Hi all, So guess i best introduce myself, my handle is colenzo, but im also known as Em! I live in the wild and wildness of the far far far southwest of england and I thought I knew a lot about access and excel until i joined up here cos i couldn't do a damn thing with my database. I also...

Hi all, Having looked through the forums and searched for something to help (to much avail) I thought i would ask the question. Im a complete beginner at access, and whilst have managed to figure some things out, have completely stumped myself when it comes to setting up the required vba code...