Search results

data manipulation I tried to do your suggestion in an update query and it didn't work. but when I give it a dummy variable it does work in a simple query. Would you know what it doesn't work?

disregard my previous question the date is mapping directly to the reason table,which has the same structure as the report card table the only different is that is mapping the comp_id, instead of the companyname. Thanks for all your help.

i have attached the file with the changes I have attached the dabase with the changes I made. I know I will need some kind of query in the after update event.

thanks, now i have another delema My next step is to take the updated data and inserted to the report card table and I also want to reset the value in the form. I know this will require vba code can you help

what I want to accomplish what I want to accomplish is to be able to enter the value for grade and reason1,2... and when I finish updating the form I will like to add tha update information into the Report Card table.

I under stand your advice but for productivity purpose I will like to just have a solid form and that's because I will be able to update the data in a 123 step. But I only need to display the companies that have a value of 1 in the current client in the client2 table.

dynamic form I would like the form to display only the companies name that have a value of 1 in the current client field. would I need to use arrays to archive this.

what do you mean by repeating group Ok, I understand that I can not update because I'm linking the tables. How would I be able to have the company name viewable for updating purpose. In the report card table I have a field name current client which is what the flag that Identified the current...

I'm trying to create a dynamic form, but I'm not being sucessfull. I created a query call frmReportCard that is using two tables one is a listing of Clients and is link to the Reportcard table by comanyname. When I open the form the option button are not accessablle can anyone please help me...

Thanks Thanks for the info. I'm heading to a long journey with this task. I believe I'm just going to have to put it together.

Thanks Thanks, I took that I approach the only problem is that we have at least 100 servers. I guess I'm going to have to just do a searh in all of them. I was searhing as *.mdb.

Hello, I wonder if any one could help me. I was giving a mde database to crack, and the reason is that the person that created resigned and didn't gave us the location of the original dbase. I was able to link into the .mde file and get the passwords of the user but I'm not able to open any...

:confused: I need to create a report that will display the total number of hours a person spend working for a client for the week. the second part of the report should display the total number of hrs of sevice spend in a client per week. I have attached a sample database of my database. my...

thanks Thank for all you help.

I created a list box, which contain company names, but I will like the user to be able to hold down a key to make multiple selections. which event would I need to update to make this work.?" In addition once I select the company I will be opening another forms with diciplines. I will only want...

I created count crosstab query and I would like to map the value 0. I'm inserting the following iff inside the wizard function. Topic: IIf([QRYWorkflowReport]![Business days open 2] Is Null,0,[QRYWorkflowReport]![Business days open 2]) but when I run the query I get null value's can anyone...