Search results

Hi, Thanks for the reply! Where abouts do i put the code '"NewFieldName:[Datepaid]" & "" & [Description] & "" & [Amount]'? Does it go in the SQL view or the Design View?

Cheers namliam for hte reply. The reason I can no longer do the frist suggestion is that i dont know who will be downloading the bank details now so mistakes are more likely. I would like to make the importing fool poof rather than replying on someone getting the right date. I also missed out...

Morning everyone! I have a little problem Im sure you can help me with. At the moment I get a spreadsheet from the bank every month which i import into our database. At the moment I do this on the last day of the month first thing in the morning to ensure there are no duplicates. I was asked...

Morning! I remember doing something like this in college years ago but I have no idea what its called to search for it. I have a piece of code that I want to repeat a few times but I dont want to just copy the code 4 times over. I would like to know what its called when you write the code you...

Hi, Im using some Visual Basic code Ive cobbled together from this site to export some data from access to word using bookmarks. The code I have used works great apart from one little problem. If a field is left blank, which in some cases it will be, then I get a 'Type Mismatch' Error. This...

Morning! Can anyone point me in the right direction. Im looking for a web page or help document somewhere to explane how to do bookmarks. All I need is something that will help me export the name and address of a client from the data base into a letter in word atthe click of a button. Ive...

Hi guys, I have a problem. I have 2 forms, 'frmClassList' and 'frmDailyCash'. 'frmClasslist' contains 7 records, monday to friday, with the classes that are on that day on each record: clDay / Class1 / Class2 / Class3 monday / Aerobics / Spin / B&T tuesday / Pilates / Tone / Circuits...

That works! Cheers

Hi, This is a simple problem but I cant seem to find the right code to go with it. I have one with one field and one button. What I want to do is when the button is pressed a new record is created (done this part already) and the date is automatically filled into the date field. This is the...

I took some working out but i got there eventaully! Cheers!

Is there a way I can disable the middle mouse scroll wheel from flicking up and down records? I have a main for with client info on and when i click a button it opens there bank info form. the problem is there will only ever been 1 bank record. Ive taken the naviagaion buttons of the bottom...

Sounds about right! Only takes a few days for your body to start flushing out the crap and utilise the extra nutrients your putting in! Now all you need is some exercise and you'll be a proper health freak :)

Yeah, theres a skeleton doing a few squat thrusts in the gym right now :)

Hi gary, Theres nothing wrong with taking a good multi vitamin as a 'safety net' to ensure all your macronutrients are taken care of but as everyone has said it would be best to get them form natural food like fruit and veg. Also there are other sources of Healthy fats that you get from fish...

Hi monkey! I work in a gym and Im a personal trainer so Im gonna say joining a gym is not a waste of time aslong as the gyms a good one and the instructors are good. watch out as there are alot of instucrtors out there giving faddy problematic gym programs out there which will do you no good...

Wow I never knew those icons existed :) Cheers!

Hi everyone! Ive had a search through the forums and I cant quite find the answer to my question so here goes. I have a membership form which displays all members information. On the form I have a header which contains a few buttons to do various things and I would also like to put on there a...

Works great! Cheers Phill

In my query Im using the criteria ="cashpayer*" to bring up any records in this field which start with cashpayer but its not working. Is my text correct? Cheers Phill

It works perfectly! I cant believe that took so long and was so simple! Thanks everyone, I felt a learn alot from that little problem! Cheers Phill