Search results

Yea, but then how do I pass variables into the queries criteria? But yea, i just need the code which will loop through the records it finds.

Well it would be natural, but it will be used for multiple bank accounts. I'm creating ready for University in a few weeks time, so it'll be used for about 3 or 4 accounts, so remembering all of the recurring ones could be a pain. I can't guarentee it'll be run everyday, but i'll get it to...

I've got a table which logs whether the transactions have been completed for that day. if they have, then it won't do them again, if it hasn't, it'll check if there are any to be done, then do them, then log that they've been done. At the beginning of a month, it'll remove the log of completed...

yea but then i'll have to put it in on the date every month, and if there is more than one on that date then i'm putting it in every month as well. If i stored it in another table and just stored the day number, it would do it automatically every month no matter how many there were, then i only...

If i put them into the transactions table then they're logged, the money is logged as gone in or out, and it becomes completely manual. I'm looking for it to be automated, so that when I run the system, it simply creates the transaction if there is one or more to be done on that day and then it...

I have a table which stores all transactions performed on a bank account. I've now created a table which allows the user to enter in any transactions that will occur on a monthly basis, and the day number that they occur on. What I want, is some code that will check the table for any that are...

Slightly confused, do you want to just form a relationship between tblSales and tblSaleDetails, or actually transfer the data, or both? For the transfering the data, either create an append query, or do it in SQL in vb

Glad it's all working. Let me know what she says to it. Glad to help Thanks for looking, i'm about to upload a good hundred or so more from our holiday to Canada so keep checking it :) They're much better than what is on there

well the office developers tools doesn't make an exe file, it instead creates an msi file which will do the same thing, it just doesn't offer the flexibility i need. If i can't find any programs out there to do exactly what I want, i may just create my own one :)

Yea i'd thought about a batch file but it can be a bit confusing for your average user. I was going to use it for registering the DLL file once it was copied, but i'll take a look around for some installer programs. Thanks :)

I'm looking at creating an automated system to install the database. I know that with the access developer kit it includes an installer package creator, however it doesn't have some features I'm after. Basically, I want it to obviously copy the database file into a folder (that the user...

haha I would so love to see that!!!

Hey sorry about the long time reply causing you to bump. Been a li'l busy. Have got all your buttons working, hope it's ok :)

Well at the moment it comes up saying that either the back end doesn't exist, OR the computer is switched off. Please check the computer first, and if it is on then relink the back end

I think i'll do either the text file or testing of a folder, and talk with them about either a NAS drive or a small server which as you say is cheap, and I've got a spare computer they could use. You see they can't spend too much money as it is a charity so they don't have loads of money to...

well the computer isn't a server so it gets turned off daily which is a bit of a pain but that's life. I'd thought of testing a folder for existence. Basically the computer holds the back end, and I wanted to have 2 error messages. One stating that the computer is simply off so the back end...

Yea that's exactly right. To create the other button do exactly the same thing, only copy the code from the return command button, and again just alter it to have the same names as the list boxes you're using :)

You only want First name and MI in the combo box columns? If that's what you mean then just edit the query that is its record source. If you only want those bits of information on the form updated then it'll be harder I think.

There ya go. All was correct, only that the query was still looking at the ID field on the other form, not that new one :)

Nah don't copy the query, just create a new one. Delete queries are easy. If you create a new query in design view, and add the table you want to delete the record from. Then at the top of the screen you should find the query type, if you change it to a Delete query then set the criteria