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...

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...

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??

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

Hi im having real problems trying to setup a purchase order section of my database. I need a basic form that one member off staff fills in, it needs them to fill in the product number, description quantity, price on the form and i also need a box that calculates the quantity x price field, then...

Im so stuck! i have a form based on a table for a purchase order, as you can see on the attachment, i have certain boxes on the form header and footer for example the purchase order number because it is only used for that purchase order the problem i have is i need the the form design to be able...

easy one i have a table and need a total field adding before i create a form on it my table name is tblPurchaseorder and the two fields i want to calculate are called quantity and price what expression do i type and how do i get it to show the total in currency? cheers dane

hi i have a query which from a courses table should show a list of people and what courses they have taken which expire in two months from the current date (the current date being the date the query is run) i have the following in the criteria to run this query >=DateAdd("m",-2,Date()) but...

hi i have a link in my database which takes you to a file in word. when you close this access is minimized how can i have it permanantly maximized??? any help much appreciatted. dane

seeing reports I have my main menu and other forms in popup and modal, when i try to open a report it opens it behind the forms and you have to close the forms to view the report is there anyway you can get the reports to open in front off the forms??? cheers dane

Form Can anyone send me a sample form i can use that does this: I need a drop down box to select an employee from a list, then to boxes to enter a date from and date to, then a button which when pressed brings a form up with the work the employees did between the two dates entered??? any help??

How do you learn wot the code in VBA and SQL is i really want to learn it so i can be able to edit it etc? cheers dane

Can anyone help please. attached is my database if you open it and look at the jobs table i need to create a query that shows the employees that have worked for each location example: Location Date Employee BP Cleeton 01/02/03 Shaun Newman BP CLeeton...

how can i create a form were you can type the two dates you want to show between from another table and a list of employees from another table then a button on the form which creates a report showing the employee you chose from the list and the dates you entered??? any help much appreciated...

Hi i have a form where you can add a date and locaction were an employee is example: DATE EMPLOYEE LOCATION 01/10/03 Jon Jones BP Cleeton 01/10/03 Mike Smith GDF Anglia 02/10/03 Jon Jones Holiday This works fine but you can sometimes enter...

hi i have got a form which allows users to choose an employee they want to see choose 2 dates to view and then a calculate button which calculates the amount they worked between the two days and produces a report on this. so far this works but only with the date that is in on default 01/11/03...

how on a query do you get it to show results that only have a cross in the tick box???? please can anyone help? dane