Search results

Hey guys I have a query that is fed a year period number (eg 200303) by the user and works from that. This query is then tied to a form and the form displays the results. Is there away to also put the year period entered into the query on the form so I can use it later. i.e query requests yr...

Thanks both of you very much. So incredibly fast with the answers. :eek:

Hi again. I've been using this line to link to recordsets :- set rs = db.OpenRecordset("Rates") So far it has worked fine, but they've all been tables. I now need to do the same but with a query. Set rs = db.OpenRecordset("Rates Query") This query selects records depending on 2 values...

Thanks mile :D

Hi Guys :confused: Is it possible to change a forms record source from within an event procedure? i.e Form Rates record source is currently Table [x] and I need to change it to Query [y]. I will then need to set which field each of the text boxes uses in the new record source. Basically I...

Alternatives always welcome Thanks Pat, I'll give that a go. Could be significantly easier.

Thanks Mile, useful advice as usual, and very quick. :o Feeling suitably stupid for not getting that one, particularly having played with append queries a few weeks ago. Just didn't put 2 & 2 together.

Hey everyone, :D I have 2 tables. The 1st table stores details of invoices sent out to clients for paying. The 2nd table stores details of projected invoices, and when to send them out. What I want to do is allow projected invoices (2nd table) to be "promoted" to actual invoices (in the...

An attempt Hey Malcy Saw that you were browsing the forum so hope you find this before you go. I'm not brilliant at reading the code, but from the rest of the posts I think I may have an idea. Could you not clear strEmail to null after each loop, so it doesn't include the previous addresses...

Thanks for your advice. When I get to that part of my task your advice will be useful. Plus, by then my coding abilities should be up to automating the task. Hopefully your advice will help Ramu as well. Cheers :D

Can't alter fields, only add or remove them !? Hey thanks for the reply. I looked about in the help files for quite a while. I couldn't find the specific contents part you mentioned - I'm using Access 2000 if that makes a difference - but I eventually found a small reference to the ALTER TABLE...

My goal was set to make sure the database I create can handle all the data it is going to need (a management system). My bosses first desire was to make sure I could retrieve the data from the foxpro tables as previous attempts have failed. I am a placement student working on this task, so I am...

I am importing data from Foxpro databases as well. They change daily, although the aim of the database I am making is to put them into retirement eventually. I have made a form which has on it just a couple of buttons which run the various 'make table' queries. It also strips away some dummy...

Any ideas anyone Completely stuck on this one - any idea? :confused:

I also would be interested in a solution to this one In the near future I will also need to import information from a spreadsheet into Access. It will be timesheet information that is input by the corresponding member of staff, and it needs to be collated in the database so that various forms...

I have a large table, filled with Timesheet information that includes a column called Year period. This is a 4 digit number, that identifies the year, and the number of 2 week periods in that year. eg. 9804 is 1998, 4th period into the year. With them being 2 week periods there are...

Found a solution Hey Kodo Thanks muchly for your help. My solution was to include the code you gave me on the OnGotFocus for the button. That way, it runs the code, and inserts the default value before it runs the OnClick code and brings up the error. Private Sub OpenTimesheet_GotFocus()...

Greetings. In a table I have a column filled with 4 digit numbers. I need to convert these number to 6 digit numbers. The conversion I have worked out. However, the column properties only allow 4 digits. To make it 6, I have to physically go in to the design view and change. As the data in...

I did what you suggested. And it makes perfect sense. But it still displays the same error. Whatever is triggering this error happens before that code you had me add. The message I am getting is :- Do I need to add "Optional" to the function call? :confused

I've had a quick look around, and it seems it should be possible using something along the lines of : If Me.txtbox.backgroundCol = "numerical value of a blue" Then etc. But I'm not sure of the syntax. I think all an objects properties are available somewhere, and the background colour is one...