Search results

hi im trying to email a report using a macro i have got it to send the email but the only format it will send the report is HTML, Ms-Dos text or snapshot. When the email is recieved you can see the attachment but cant open it. (its grey/shaded out) Anyone know how i can open the emailed report...

Hi can anyone help me i need a button to open and show you the contents of a folder on my network. Is there anyway off doing this i tried in a macro by doing a runapp but it wouldnt work. Can i do this without using the code? Cheers Dane

hi, ive created a log on form which is based on a table i have with three users and their passwords. on the form i also have ok and cancel buttons. When the user chooses his name from the drop down list and types their password into the form and clicks ok i want it to check with the table to see...

ive tried importing your logon example into my database to use it but when i try and use it, it brings up errors in the code? i have designed a logon form myself and got a table with the 2 users names and there passwords but how do i get it so that when you type the name and password and click...

i want to create it a bit like you have but im doing a query but what do i need in the criteria so that it the data in the form has to match that off the table? thanks dane

Can anybody tell me how i can set up a password system onto my database i have a table with the 3 names i want to use and there passwords in the password format but i dont know how to set up a form so the only when the name and password you enter on the form match that of the ones from the table...

sorry im a total novice that made no sense can you help explain how to do that again please?

ive created an order form in a report but need an item no adding but if i just add it in the table it just keeps adding up but i need it to start at one for each order. any help much appreciated dane

In a report how do i create a box with a total of prices on the report to go in the report footer??

nope im wrong it still keeps coming up. Can anyone help??

Its ok ive solved it if anyone else gets this problem, if you have norton anti-virus installed turn off script blocking feature!

No it still keeps happening, i cant work out why??

when i click on some buttons on my database it keeps popping up the error message - a problem has occurred while access was communicating with the OLE server. What is the OLE server and how do i stop getting this message? Any help much appreiciated Dane

i now have table with the two different names of people who can access forms etc and their passwords , how do i create a form so that they have to fill in the name and password and only if its correct they can open another form?

right ive got the query done for the form. how do i change the setting though for the form which the MD sees so he can tick the tick boxes and enter a PO number? this help is really good thanks guys dane

i have the basic tables set out now. how do i link them into a form im guessing i have to run a query on it as this will be how i get the total field (quantityxprice) but dont no how to get the query to work

yer later i was going to setup some security on the database so different users have different levels off access.

ok ive got these but how do i get so that only the MD can authorize it and the member of staff can only print it out after its been authorised? cheers dane

Yes it is but its just a text field added onto the form header so i cant use that to group my orders according to the order number can i? i think i have got the design wrong. Do you have any suggestions??

No, what i mean about separating the orders is that all the products ordered are saved in one table so you cant tell what products are from which orders. The order numbers are just typed in by the person who authorises it. i have just two tables relating to the form one table, purchase orders...