Search results

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

Hi folks! Query: What I want to know is do objects in an access form have a "type" element that can be accessed through VBA? In essence what I'm trying to do is assign a colour to every label in a form as it opens. In the on open I currently have: For Each label In Me.Form If...

Sorry that does seem rather circular and probably the worst example Theres a bunch of things on my form that I want to spit out into my table via the append query. These things could be ascertained using an extra query... I Was just trying to be fancy and avoid using 17 queries to derive the...

Hi there! I'm trying to use an Invoice number from an Invoice form to populate a table of Invoice Lines with relevant records (linking by Invoice number). I realise the following SQL code isn't an append query, but I've simplified it to make it easier to explain SELECT...

Cheers ghudson... nice work! Call me a forum n00b if you like!! I was trolling instead of searching... I ended up initiating the status bar progress meter thru the syscmd function. Seems to work a treat, but I'm sure your code will come in handy! *bookmarked*

Hi I'm having a similar issue.... Basically my code goes a million miles an hour and does about 6 things... at the end of each of these 6 steps I'm trying to output a message to a text field on my form to let the user know whats going on... Only prob is the code executes WAY too fast and when I...