Recent content by alexi

so there is now way of calling up a web page, downloading the code from the page, and then referenceing it to the database? so u would put the code in a temp table or something?

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

i mean fields. in the query i hvae six fields. in the listbox i have the column count set to six. with the crietria out, the columns are filled. when the criteria is in, onlyy the column with the criteria on it is filled.

sorry for the late response. what i have done is created a query for the listbox, and that works. Except with the criteria underneath the Primary Key field of the table, the rest of the fields dont show up in the listbox. when i take the criteria out, they showup again. any ideas?

Thanks for that but i cant get it to work. I know there was another way to do this but i still cannot remember. iT was putting something in the listbox to link it to the combo. Any other ideas? this is what i have put in. Me.Symptom.RowSource = "Select SrchID " & _...

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

there is 3 that are calculating things off the tables. these are expressions not sums but same thing yeah? but each of these is attached to an entry (by a taskID). so i dont want each time a taskID is entered to show up, but the totals for each task and everything under that.?

ive just tried that but which should i change to a sum to get it to do what i want?

ok ive done what pat suggested in the first reply by creating some tables and appending to them. this works ok, however the query shows every entry from the timesheets, so each time a task is worked on it shows it, what i want though is a sum of all the hours etc under one task, not every time...

i dont suppose you could give me a bit of example code for this? im having trouble finding any?

ok, thanks for this by the way. i have tried this before, open report report!control.name = forms!control!name close report this gives a random line from the report over to the form. anyway of getting them all across using this method? like a loop or somethin?

ok i will try that, but is there a way of moving the info fro a report to a form?