Search results

ill try and attach the missing forms. the databse is 13mb and when in zip its to large to upload. do you mind downloading from a link?

the answer to your question is no. i did struggle with it myself but it is exactly the same on the other databse at our 2nd site and there are no errors on that one which exceed system requirements. its not that

i have had to take a few forms out of the database as it wold have been too big, even with it being in a zip file. i have left the important forms and the forms where the errors are occuring. the error occurs when i am adding a record to an appointment. open the database frmPasswordScreen...

are you on 2010 or do you need it to be .mdb

no. theres over 50gb remaining. i cant work it out.i thought that if it was something to do with the tables then it would happen every time i try to add a record. if it was something to do with the ram or hdd then it would be obvious through the system. nothing seems to be indicating what it is.

i have built a database with much help from the guys on here. we used it in one premises with the idea that when it is complete or near to completion(new ideas always come) we would use it at our other premises. the databases are not connected in anyway and are run as completely seperate...

sorry but i put the statement in brackets to prevent a reply like that. if it loses focus will the code run

i have a form with a timer event. it refreshes the time txt box on the form every sec.(i have been told about other ways to do this so the question is not should it be a sec or not) the event for the timer then is If txtbox=09:00 then code code code the event runs at 9am. this is the time...

thanks milhail. im now wondering if it is possible to do it in one query. more liek the one i did earlier. i prefer to keep everything as tidy as possible.

sorry milhail. its the OrderID's i want to count. but in the tblOrdersItems the are many of the same as it is one to many tbl system. if you put this in then at the bottom of the screen where it shows Record 1 of 87. 87 is the number i want in a field. [code] SELECT Count(("SELECT...

i have just tried this query in another query first one SELECT tblOrders.OrderID FROM tblEmployeeItems INNER JOIN (tblOrders INNER JOIN tblOrdersItems ON tblOrders.OrderID = tblOrdersItems.OrderID) ON tblEmployeeItems.EmployeeListID = tblOrdersItems.Employee WHERE...

no, you see the access record count at the bottom. i want that value in a row. im usually very good with queries but this one i am stumped. im not sure if the criteria (EmployeeListID) is having a bad effect as it is forcing me to include tblOrdersItems. i could do it in 2 seperate queries...

sorry i havent responded for a couple of days. i know the rules for database build. not duplicating data, not storing calculated data. i have tried to follow them where ever possible but i have never understood why. i know that in effect, calculated data is duplicate data.( im expecting a raft...

i have 2 tables. tblOrders and tblOrdersItems. tblOrdersItems is the child and tbl Orders is the parent. the linking field is OrderID. i am wanting to count all the OrderID in tblOrders. the criteria i need is EmployeeListID which is stored in tblOrdersItems. when i put these tables into...

ok ive stuck it into .mdb. on open frmPasswordscreen will open. enter s4ut21 into the text box and press enter. ignore the error. then open frmClientSale. select a name and click 'Payment' then on frmclientSalePaymentScreen click Add course. select a course item in the list box and click...

Blaster, i get your point about calculations and i have stored calculations and duplicated data all over my database. the one simple reason is that if my item cost 10 today and i change it to 11 tomorrow then all the records that have the same data will automatically change. same with this...

hi milhail, i have tried CDate and i now get a Type Mismatch. i dont know why im getting this as the field it is going to is Date/Time(Short Date).

yes i am sure that column 5 contains DateAdd("m",3,Date)). i have just doubled checked in the query builder of the list box and it definately shows it. are my " & correct. i havent used any because there are not any in the previous rs!.

oh, if only that was it. thanks for pointing it out though. i not get an error of data type conversion error is what i am doing possible?

i have a tbl that stores items that have an expiry. in a child table i want to store the expiry. but as it is different for each item i need a way of doing this. i thought that by having DateAdd('m',3,Date()) in one of the fields this would work. on click event i would like the date add...