Search results for query: *

Worked perfectly. Thank you,

That runs fine the problem I'm having is that I need to delete the items from the archived list. So when I try to reference that table is where I am getting the error stating it cannot delete.

Deleting from Tasks

I haven't been able to find anything regarding this out there so hoping someone may be able to help out. I have a list out on SharePoint that I link back into Access to query and run reports based off off. I have a query that runs to archive these records each month to a table. What I need to...

Hello everyone, I am trying to set up a search function within Excel but not sure how to go about doing this properly. I would like for it to work just as the Find and Replace function does as there is the possibility of a lot of data to be in some of these cells. I've tried to set up a...

Thanks, that worked perfectly. I guess I did have a little hick up in there.

I guess i'm a little confused on the compiling portion. But the database does open properly and function properly before trying to create the MDE.

It doesn't even get to that portion of compiling the database it just just shows that access is not responding.

Hello, I have created a database in which there is the back end and then 2 front end systems. I have successfully created 1 of the front end's into an MDE but when I try to create the other one into an MDE the conversion never finishes. Any ideas on what could be causing this problem?

Works perfect. I had the Where statement in there wrong I put the = sign outside the " Thank you so much for your help with this, I only get to work with access about once every 6 months so your help is greatly appreciated.

I need this form to open up and reference that Session from the list box. When it references that SessionID it will populate the remaining fields with the information listed under that SessionID This also has a subform on it so that multiple entries can be entered for that specific SessionID.

That worked. Now I only have one more problem. When opening frmLongEvaluation would I put in an argument on the form itself when opening it and if so how would I code that? Or would it be better to reference it in the query that it is based on under the criteria? I don't know how this would...

That seemed to work, except now it is telling me on the DoCmd.OpenForm portion: Wrong number of arguments or invalid property assignment DoCmd.OpenForm "frmEvalLong", , , , , , , Me.ListEval.Column(0) When opening the form I need to reference the first column in the list box

The name is correct and the values are correct. I am not listing a 1 in there due to the query that populates the list box does not include that value. I need the code to reference the information contained in the list box such as the row selected (SessionID) and the column (Evaluation).

No I don't. It just gives me the option of the list box itself. Is there a better way to set up the coding on this to reference that specific field in the list box?

I have a list box on a form in which it's value is based on an option group. I would like to open a form based on that value. For example option 2=long evaluation, option 3=short evaluation, so if the value in the list box is 2 I want to open frmLongEvaluation when I double click on that record...

Stupid question where is the tab property located at? I can not find it anywhere under the properties of fields

I have the fields set to required in the table. I'm not sure how to go about setting up a routine to check the fields. Any example you could give me would be great

Hello I'm trying to hide multiple command buttons on a form until required fields are completed. I have been successful in hiding them based on 1 field but not sure how to go about hiding them until all the required fields are filled out. Any help would be great. Thanks,

Thanks, looks like the calculation is going through now but is there a way to get rid of the error# in that field so it shows 0.