Search results

Gday, This may sound like a strange request but it would be sensational if it could be done. What i want to do is pull information from a web page and put it into the appropriate fields in my database. The web page is java based and defines all the variables that i need to get info from...

gday, i have completely forgotten how to do this but what i need to do is select something from a combo box, and then have all the related fields be displayed in the list box. i just cannot remember for the life of me. any help would be appreciated cheers

Gday, Does anyone know of a way to have a subform pop up only on the press of a button? but still be linked to the original form? so when ur scrolling through your records on the top form, the subform also changes respectively? Ta

Gday, I have a little problem im hoping someone can help with. I want to append a figure from a query, to a table that already exists. I need The number from the query to put itself in a column of the same name (actual cost) in a table called tasks, but to be relevant to a jobNo and a Task...

Gday, I have a query in which it has information from a table that has been entered from a timesheet. I have 3 expressions in it, which tell me the cost of hours, chemical and plant. However, this calculation is done on each line, or each entry from the timesheet. I want to group all the tasks...

HELP! I have been stuck on this one for a couple of weeks now guys, can anyone help with some ideas? I create an invoice report from some specs which i select on a form. This generates the invoice report once. However i want to be able to edit the data and save the data on this invoice. So...

Gday Guys, I have a question regarding the OutputTo Cmd? THis is what i have DoCmd.OutputTo acOutputReport, "rptInvoice", acFormatRTF, "\\Bbcg1-jacqui\f\Personal\Data Tracking\Invoices\" & Inv & ".rtf" Where Inv has been set as a path to a form Now how do i get another directory under...

Gday i have a series of *.rtf files in the dir c:\invoice on my comp is there a control i can use on a form to view these files in access and then double click to open or preview? Ta

Gday guys, I have a problem with an idea i have. I create an invoice from a form, which allows me to select the job and task, and then this runs a query wqith this information and spits out the costs needed on my report(with a few calculations on the report). what i need to be able to do is...

Sorry to do this i know im not supposed to but i need help with this prob. i have to have it done by lunch time today and i can figure it out. sorry

Hello people. Could you please help me. This one is a little hard to explain so i;ll try my best. I have an invoicing system. I Open the form, select which job i want to invoice on from the left list box, then the appropriate task no's for that job appear in the right list box. i select which...

sorry guys the previous post's reply is me just appending somethin in the question any help would be appreciated

hello, i have a form in which i select a job no in a list box, that then showes the relevant tasks for that job in another list box in which multiple select is allowed. i then put the folliwing code behind the view report button Private Sub cmdPrint_Click() Dim strWhere As String strWhere =...

I need to run an append query and update the information on a form I have a quote table, i enter a quote number, name, description and customer. I want to then go to the jobs form, hit a button, request a new job number, and then ask what quote number i would like to turn into a job. This part...

i was told to put this code under On Requisite, but i dont know what that is so i put it under On Open. Private Sub Form_Load() Dim db As DAO.Database Dim rs As DAO.Recordset Dim qdf As QueryDef 'Note that YourDuerySQLstring should return one record Set qdf = db.CreateQueryDef("", "SELECT...

What is the on Requisite event? is this another name for somethin else?

Can this be done? i have a form in which i enter new jobs. these job no's have corresponding tasks, and each of these can be ticked completed, invoiced etc. one of the fields though is an actual cost. now for me to get the actual cost i have to run another report i have(Job Actuals) to get the...

i want to get a thought of the day text box on my switchboard i have put them into a table labelled tblThoughtOfDay now each time i open the switchboard, i want it to randomly select one of the thoughts and display it? how do i do that?! ive tried and tried and cant figure it out ta

can someone help me with this code? Function DayOfyear(Optional dteDate As Date) As Long If CLng(dteDate) = 0 Then dteDate = Date End If DayOfyear = Abs(DateDiff("d", dteDate, DateSerial(Year(dteDate) - 1, 6, 30))) End Function Sub Test() MsgBox (DayOfyear *...

Can anyone help with this one? I need to accrue Annual leave for full time employees. It would be at the rate of 0.0547945 every day for 365 days to equal the 20 days of annual leave granted. i need something to work out for each day then add that number to a running sum next to each...