Recent content by Terri Hdokins

Fixed It I figured it out. Thanks, Terri exp: IIf([RanchPlot] Like "*X*","WideBed","Conventional")

I have a field in a query called RanchPlot. I would like to have an expression that if there is an X in the RanchPlot field to put in Wide Bed and if not give me Conventional. Thank you for your help in advance. Terri Wahlberg :confused:

I hope someone can help me because I am really stuck. I have 2 problems. 1. Before I delete a table in Access and bring in a new one I have to delete a relationship. At one time this code worked but now it is not. Private Sub cmdRemove_Click() Dim db As DAO.Database Dim rel As DAO.Relation...

Re: Filter I have a button on a form that will open another form and filter based on two fields. My problem is someone who was using the database hit the filter button on the toolbar when the form was open and now my form will not work. Please help!!!! Thanks, Terri Hodkins

Thanks so much for the feed back. I know I can get it to work by doing Case 3 but I think I am going to try your other suggestions. I will let you know. Thanks Again, Terri Hodkins

When I set my first subform record selectors to yes my second subform does not requery. Do you have any suggestions? I would really just like all the records selected in the first subform to display on the second subform. The only records that are related to each other are the invoice...

I checked my second subform out. It is set to continuous and my links are as follow: Child:Invoice Master:subDetailActual!Invoice What is happening is there are invoice numbers that appear in the first subform. Then in the second subform there could be many records with those invoice numbers...

I posted a question yesterday in regards to linking 2 subforms. I figured out how to link the two but my second one only displays the first line from subform 1. I need it to display all lines from subform 1 that have the same invoice number. Any suggestions????? Thanks, Terri Hodkins

Does anyone know if you can link a subform based on another subform? My problem is both subforms are linked together with the main form based on one field which is the sales week. Then the first subform has invoice numbers that match to the second subform. I would like the records in my...

The following code delete's a table and create's a new one. I would like to be able to bring some of the currency fields in with more than 2 decimal places. Does anyone have any suggestions? Thanks, Terri Hodkins Private Sub cmdGrowerSalesAudit_Click() On Error GoTo cmdGrowerSalesAudit_Err...

I finally figured out how to delete a table and then create a new one. I am now stuck with not being able to add any more columns. My formula doesn't want to allow me to add any fields with the value as DATETIME. I would greatly appreciate any suggestions. As you can tell I am very new to...

Do you have any suggestions for an execute method?

RE: CREATE TABLE I am trying to run a VBA code that deletes a table and then creates a new one using DoCmd.RunSQL. Does anyone have any suggestions for syntax using the CREATE TABLE. I keep getting error messages. HELP!!!!!!!!! Thanks, Terri Hodkins

Thank you so much!!! It worked.

Re: If... Then... Statement I am a little stuck right and came seem to get my VBA code to work. Let me see if I can explain. I have a master table called "tblWeeks" which contains all sales information by weeks. Then I have a temp table called "tblTemp" in which I use to bring in my week...