Recent content by horsecow

ok, will do. cheers

hello, I am having some serious problems with the most basic aspects of creating a query. I am trying to do the following: Take a date entered in the database already (Date of Hire) Then take Length of Hire (number) and Length of Hire (Week/Month) and times them together. (Lengh of Hire...

hello i have a form with one textbox in it. The record source for the form is a query. the control source for the box is one of the fields from the query. The query either returns "not instock" or nothing at all. The text box does exactly this at the moment. No problem at all. But when it...

hello, the tables in my database are designed suitably for what i needed them for. It's only today ive been told i need to add this record of the amount of stock needed to get the grade i want in the subject. I have 6 days (that includes today, 5 working days really) to finish the database and...

hello, I'm in need of some rather urgent help. I have 6 days left in my deadline and need to have my database finished (i thought it was) and more importantly, all the paperwork to accompany it done. What i want to do is have a field in a producttable called "stock" and in that field will...

hello, I'm in need of some rather urgent help. I have 6 days left in my deadline and need to have my database finished (i thought it was) and more importantly, all the paperwork to accompany it done. What i want to do is have a field in a producttable called "stock" and in that field will...

hey, thanks mile-o-phile i was just aboutt o reply and say i couldnt get it to work, that when i pressed the refresh button all the details from the lst disappeared when i decided to reread what you had said, i had forgotten about setting that string variable. Now i have no idea what a...

sorry to be a pain but could you explain that a little more for me. this si the first database ive created myself (for a school project) so im a bit stumped. I assume the button would have something like onClick lstColumn Rowsource = SELECT tblCostume.[Costume Reference Number]...

hello, i just found this topic as i was lookignf or a search form too. This isnt the idea i had had, but it works perfectly and ive been able to use it and implement it into my own database (for instance, ive got multiple text boxes and commands searching for the different fields in the...

no matter, now, found a thread on the forum which has help edm eout

the page footer ar the bottom of the report. EDIT, i just did a little experimenting and found that if i put the expression in the detail then it works... but i dont want tit to be repeating. I just want it to appear once at the bottom of the report (in the footer i presume) 2nd Edit, and...

hello im making a an invoice form a report at the emoment. There are some headings in the ... header, and the details int he detail. There's the amount of days, preice per day, and the total price. I am multiplying the days by the per day price to get the price using this.. =[Length of...

im only doing my first databse now so im probably not going to be any help, bt the way i would look at doing it would be to make it so when they input a new record via a form a macro is run that runs an external program. All this external program would so is send an email to a set email address...

Hello, Sometimes when i import an excel spreadsheet into a table in my database it gives me an error about how not all the data was input correctly. I go and find out which record wasnt input correctly, go back to excel, delete all the other records int eh sheet apart from the one that didnt...

thanks, that's given me another angle to look at it cheers