Recent content by IR_Moon

Hi there! I've searched all over for a solution to my (well my users) recurring problem. I have a form which holds invoice data in it. This is for incoming invoices - i.e. generated by other suppliers - stuff we pay not stuff we're paid for. On this form I have a subform that contains all of...

I would figure the best way to do would be to use code. I';m looking at doing something similar but definitely will be using VBA... and in fact I'm not sure you can put something so complex into a Macro. The real issue is WHY don't they want any code? that seems a little odd to me. The...

For some off reason, mine worked (and succesfully selected the first item in the list box) when I changed the code to: lstReference.Selected(1) = True Not sure why or how or whatever... but the 0 wasn't working for me... or it was selecting some random record in big lists. Anyhoo... try...

Greetings! Nice to have you here :D

FYI: As a workaround for now, I've written a batch file which copies the existing Shared database on the network map drive to another location, and then I'm using the VBA FileCopy command to copy the copy... it's long winded, but it works.

Okay I've searched and searched and can find lots of references to FileCopy, but none that suit my purpose and problem 100% I'm setting up a "take the database home" script, which will enable my users to take the latest version of the database front end and the latest backend home with them...

Sweet... glad I could help... makes a change actually!! Every other time I've posted I've been ASKING for help not giving it :D Stick around... you'll learn heaps REAL quick! This site has become one of my most visited sites and my best learning tool. Good luck with your project!

Forgive me if this is too basic a reply for you, I'm not sure how much experience you have, and you said you were new to access It goes in the form code. If you go to design view, you can select the properties for the form by double clicking on the form selector in the top left of the design...

As far as I can see it is deleting the last record and providing you simply with a blank form. If you look at the table, you will see that the record has been deleted after you press the delete button. It certainly looks like a blank record on the form to me too. As for the problem with the...

Cheers Bob! You and GHudson both have a knack of making the incredibly frustrating into the painfully obvious without belittling the user! Cheers muchly... it's the response I was looking for... and soooo much easier than what I Was trying to do!

Shouldn't that have a * in the front too? otherwise yer only searching the start of the field, no? i.e. Like "*" & Forms!YourFormName!YourComboBoxFieldName & "*"

Hi there! I have an Access application that displays a different colour on it's forms depending on the selected client. It's kind of somewhere between trying to make it prettiful and trying to make it functional by alerting users IMMEDIATELY to which client they are entering/viewing data for...

Try the post at http://www.access-programmers.co.uk/forums/showthread.php?t=118532&highlight=file+exists also. Thats where I found the info I was looking for

Hay that's awesome, thanks for your hasty reply. the .ControlType was what I was after... My total code (just to simplify it for anyone else trying the same) is: Private Sub Form_Open(Cancel As Integer) On Error GoTo Err_Form_Open 'HideInvoices Dim ctl As Control...

Alternatively instead of deleting your whole table, you could just delete the data with a query or code, then when you are importing, don't import the header row with the names in it - This will keep the old field names, no? Docmd.RunSQL "Delete * from tTable1" 'instead of DoCmd.DeleteObject...