Search results for query: *

Hi gang, For some bizzare reason I am having terrible trouble setting up a simple query. I want to have a form where the user types two values into two text boxes (FirstName and LastName)and the user then clicks a command button. When they do access will open another form that shows the...

Hi all, If I place my cursor anywhere in my db window and move the "middle" mouse wheel access scrolls through it's records. Now I have a set of custom navigation buttons on my form that I created (with help of members of this forum) and I would like to have it so that access only scrolls the...

Hi gang, Just spent most of today and all evening trying to get this to work and access keeps giving me a "Run Time error '2489' so before I tear all my hair out can any one suggest how to do what I need. I am trying to write the code for Custom Navigation Buttons like - Next, Prev, First, New...

Hi, I am trying to write a global or multi-purpose function that will refresh or requery (what ever the correct term is) a form to reflect the updated record. The form contains normal data and has one field that displays a jpeg image (saved outside of the db as a link). I have various event...

Is there a simple or plain way of doing what I want. To me, in my mind, what I want to do is really simple.. I have a form that displays records based on one flat table. Each record could have an associated jpeg image. The image is stored outside on the db and the table stores links to the...

Hi, How can I get access to hide certain fields or controls on a form if a certain field has no data? Allow me to explain further: I have a form that displays data = frmPlantMain and a associated image = Image1 The image is stored outside of the db as a jpeg and the field in the record source...

Hi gang, I throw myself at your mercy. I have spent the last full three days trying to resolve, or work out why on earth I am getting this error message. I am at the point of pulling my hair out - its SO frustrating so *any* suggestions would be great. I honestly do not know what to do next. I...

Hi Gang, Forgive me asking for what seems to me to be the impossible. I simply want to be able to have a button on a form that, when clicked, will import and store a JPEG image that is linked to the current record. For example, if the current record is for Rose "apple wine" then when i click...

Hi Guys, I have a access 2003 database that I am creating for arciving plant details. I have a bound object field that stores a jpeg imige of the plant and displays this when the appropiate record is selected in the database. (This all works just fine). What I need to do now is to have a...

Hi Guys, I have a bit of a problem that I wondered if anyone can help me with. I need to be able to change the case of text contained inside brackets to Sentence Case (Each Word Starts With A Capital Letter. I need it to ignore any text before or after the ( ). It would be best for me if this...

Hi Gang, I have a litle problem thats been bugging me and I cant seem to get right so I wondered if anyone can offer a solution, Here's what I need to do. I need to show the contents of Cell A1 & B1 in cell D1 (seperated by a "-" symbol) but also show the contents of Cell C1 if it has data in...

Hi Gang, I will explain best way i can. If Cell A1 contains the time 01:30, thats 1 minute & 30 Seconds, Then I need cell B1 to display the value as just seconds so that it looks like this: 90. Again if a user types 01:00 in Cell A1 then Cell B1 should convert and display this as 120. I...

I am reposting this question as I made the mastake writing a very un-descriptive subject heading on my previous post - I apoligise if this causes offence Here is a wierd and very annoying problem: I have two copys of WinXP setup as a dual boot on my computer (there is a very good reason for...

Here a wierd problem: I have two copys of WinXP setup as a dual boot on my computer (there is a very good reason for this setup) and I use Windows Explorier all the time. On the secondary install of XP in the lefthand pane of Windows explorier there are no icons, nothing except the check boxes...

Hi Guys, Please forgive me if this is not the right forum to ask for help with my problem but I am being driven mad with frustration. I hope someone can help me with a problem that I have been trying to fix for 3 days nonstop now. First My System: 3Ghz P4 with 2Gig Ram (MSI 865PE Neo2...

Hi, Does anyone know a handy bit of code that I can put in a VBA module for a Excel Spreadsheet that actually changes any text to Uppercase and/or Sentence Case (as opposed to displaying text in a different case). Any suggestions would be great, Thank you In advance, Kenny