Search results

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

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

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

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