Search results

Happy new year everyone! This probably isn't worth anyone's time but i am stumped and a bit annoyed... I have just made the jump from 2003 to 2010 with a large database and am getting to grips with everything (a bit easier than expected to be honest) However the view i am used to for database...

I feel a bit stupid because i'm sure the answer is right in front of me! I'm behind the curve and looking into upgrading a 2003 database to 2010. I have not messed with access for a long time so am out of my comfort zone with 2010. I've let access save the front and back ends in 2007 format...

I'm using Access 2003 over a 100Mb network. The back end is about 100Mb and the front end is about 10Mb so nothing too big and they are compacted every few weeks to keep them trim. When the back end isn't being shared it opens pretty much straight away over the network (about a second). As...

I am running a split Access 2003 database (as part of Office 2003) under windows XP. I know I should have moved to windows 7 and Office 2007/2010 well before now but I'm looking into all upgrade options at the moment prior to support for windows XP being discontinued in 2014. Since support for...

I reckon i must be losing my marbles or i'm just being lazy (probably the latter). I've got a product search form with a text box (for the search string) and a "Find" button to perform the search when clicked. The user types a string then clicks enter. The focus moves to the find button and...

I must be missing something but the product shots i'm seeing of access 2010 seem to suggest that you can conditionally colour text within a form field. I have a DB containing many records and i would like to be able to use colouring to highlight specific types of record within search results...

Just out of curiosity i'm interested to see what the actual lifetime limits are for an access database specifically relevant to objects created and then deleted. I know that cretaing and then deleting objects contributes to the usage to date but can anyone tell me what the limits actually are...

I run a small business, have been trading for around 13 years and often resort to the forums for tips, tricks and advice regarding a heafty Access application that i commissioned to be built some 7 years ago and currently maintain. The Access application currently "runs" my entire business, so...

I'm trying to create a MailItem within access 2003 that includes my default mail signature from Outlook 2003. I don't have a problem creating a blank MailItem and then populating the relevant fields but i want to create a mail that already contains my default signature from Outlook. I can't...

Create a MailItem that contains an Outlook assigned signature? I'm trying to create a MailItem within access 2003 that includes my default mail signature in Outlook 2003. I don't have a problem creating a blank MailItem and then populating the relevant fields but i want to create a mail that...

I'm not looking to spam anyone or sell their data but need help to test a simple market research system that i have built. I'm looking for about 25-50 people to let me send them an email inviting them to a webform to see if the "process" works correctly from start to finish. The form asks for...

I have some data received in the body of an email that i am trying to "clean". TABs or Carriage Returns (or both) are causing me a problem because although easy using find and replace from the menu bar, i can't seem to see exactly what to represent them with in code to automate their removal...

I've seen plenty of threads suggesting possible causes for this problem and numerous suggestions for possible fixes. My Access 2000 database is split in to a back end of around 70-80Mb and 5 users on the front side. No one's exiting stupidly and nothing out of the ordinary is happening...

I have just been working with some temporary recordsets in access 2000. After working with the recrodsets each is closed and set to nothing but this leads to bloating of around 20Mb on a 70Mb backend database. So I (in messing around) I added "DoEvents" after closing each temporary recordset...

Hi, I've got a fairly complex access 2000 database that's split into front and back ends. There's 32 back end tables and a whole host of complex front end queries and forms. The whole thing's around 25,000 lines of code so not a 5 minute job to rebuild! (sorry but i just can't stop...

HiThere, I was going to go into detail about why (but i don't have FOREVER to type it all...lets just ask the question instead... Is there any specific function able to convert a number stored as a text data type back to a number data type? OR Might it be possible to create a function using...

Perhaps my brain is still awash with beer!? I was sure that there was a simple function (a bit like datediff) that returns the remainder when one number is subtracted from another. I thought i had this burried in a database somewhere but can't seem to find it. Can anyone give me a hint as to...

Hi there, I'm using access 2000 for starters. I have created one to many relationships for each of 10 cascading tables dependent on related records in each preceeding table and was expecting to be able to drill down into them in the standard database window prior to creating a data form to...

Hi there, I'm using access 2000 for starters. I have created one to many relationships for each of 10 cascading tables dependent on related records in each preceeding table and was expecting to be able to drill down into them in the standard database window prior to creating a data access form...

Hello peeps. Does anyone know much about searching techniques in terms of finding data based on fuzzy logic? I have a fairly adequate database for finding product records which currently uses text strings (in any order) and spaces as wildcard characters, to look for exact matches to all of the...