Search results

Thank you but its still not right as it throws an error (Compile Error: Method or data member not found) on Column

I have a combobox (cbo_Breed) that Holds the Breed_ID, Breed and BreedType_ID. On the form opening I want to look at the thrird column and if its a "1" then to do something. How do I get the form to look at the third column? This is what I have written (I know its wrong, but needed a starting...

OK the problem only occurs when I press ANY of the buttons on the screen grab Capture2. It is asubform of the Screengrab Capture. The problem only started when I add the two new comboboxes in screengrab Capture3. I can rectify the problem by removing those comboboxes, but I really need them...

Can somebody please tell me why I get this error (see attached image) It dosent always happen and cant figure out why. :banghead: Many thanks

My software is close to compleation, but it has raised a few questions. 1. Can I include Access Runtime on a distribution CD. 2. Am I even allowed to sell my database. 3. I intended to sell it on CD but many are asking for it to be downloadable. Are there any selling sites that allow you to...

How do I exclude something from a ComboBox please? My form is a profile of a dog and contains a Dog_ID. The ComboBox is a list of dogs names and shows all the females I want it to show all the females less the female that it is being linked with.

OK I understand that but what function should I attach the error handling code to? The cancel button is on the Microsoft Windows Print box so cant access that! Do I put it in the btn_Print code on my form? I already have code there, with some error handling. Private Sub btn_Print_Click()...

I have a form with a button (btn_Print) for printing a report. It workd fine, except for one thing, when the button is pressed, the report pops open and the Microsoft Windows Print box appears, this in itself is OK. The problem comes when the user chooses to cancel the print. They press the...

Tried but didnt work, thanks

What should happen is: The code should populate a combo box with file names from C:\GungogManager\BackUp\. That file is created when a button is pressed on another form to "BackUp the data. If not backup has been created then no file exists. When this form activates, if the file...

I have a restore from BackUp form. When the form is activated it runs this code Private Sub Form_Activate() Dim strRestore As String strRestore = "C:\GungogManager\BackUp\" If Len(Dir(strRestore, vbDirectory)) = 0 Then MsgBox ("There are no BackUp files available")...

You have to edit and save as the autorun.inf, changin ght Encoding option at the bottom to ANSI

No I checked that and I have enabled it for installing programs. Thanks.

Looking for some help on packaging my DB please. My DB is now finished and I now want to be able to put it onto a CD for distribtion. I know how to package it up which I have done. I have the packaged file set in a file on my PC (setup.exe and autorun.inf). I burnt the files to a CD last...

DOH, I had written the string incorrectly!

I am trying to add a profile picture to a dog database. The way I have it is that the picture is a file and gets renamed the dog_id, on the query for the form I have added the extra coloum [code]ImageFile: "C:\Gundog Training Databases\ProfilePictures\" & [Dog_ID] & ".jpg"[\code] But the...

My form has a Record Source of qry_Profile, it is a query that shows the user the records of the dogs that they currently own. I want to put a button in the form footer to allow the user to show the records of all the dogs that they have ever owned. So my question is how do I change the record...

On a form I have a listbox that allows me to navigate around my records. The listbox is filtered and I get the redords that I waqnt from the table. My problem is that when I open the form the record that is showing is one from the table but not one that is in my listbox. I want it to show the...

Can someone tell me where I have gone wrong with this expression please. The query is looking for a match with coloumn 1 in the combobox, but its throwing an error: Undefined function 'Forms![frm_Profile]![frm_Mating].Form![cbo_MatingDog]![column]' in expression...

Because the email is sent automatically, I found the onlty way it an be stopped is if the user has no security softwar installed. I read up last night and found that the Outlook window that pops up (Microsft Outlook Security) telling you that another program is trying to access your Outlook...