Recent content by Skip Bisconer

Thanks for your input. This will solve my problem.

I have a split form to update a table and on the form I have a clear button to clear the table for the next entries. I want the split form to requery the table after the delete query runs in the data portion of the split form I get the #Deleted in all the data fields. I know that the table is...

Thanks Bob, I am now able to use the docmd.movesize so the form is looking good. I have another problem with vba so will go to that forum. Thanks to all of you for your valuable input.

I had my database set to tab view and changed it to Overlapping widows rebooted the database and it still opens to full screen. I have my min/max property enabled but it will not minimize, just stays maximized. I have now set it back to tab documents.

No just a regular single split form.

I have a form to input to a table with only three columns of data and when I run this form it opens in full screen. I tried to use the docmd.movesize to no avail. Then I set the popup property to yes with the docmd. movesize and I get an "Invalid outside procedure" noticeon loading which, when...

I solved my problem caused by date data coming from front end in text format. I created another field in the report query and in build did text functions Left 2 & / Mid 2 & / left, 2 on the date field and used the new field in the report.

The format property for that field says short date.

Yes, when I couldn't get it to show correctly just from the reports query link I also added the mask to the date field property in the report.

Thanks for looking. The report is based on the query with the two date fields. When I open the the query the Invoice date field (the one giving me problems) does display properly using the date mask. In the report it only dispalys the 6 digits without the mask even though I have set the field...

I have I am doing a report on a query with two dates based on table and a different query, plus some other fields. The table is comprised of information created from a form of which one of the fields is a Delivery date and formated as a short dates from the form. The query is based on a table...

I get a an entry error "Expected: =" and when I try compile I get a Syntax Error all on the Dlookup Private Sub OEOO_ORDR_BeforeUpdate(Cancel As Integer) DLookup("OEOO_ORDR", "qryTotalInvoiceOrderLines", "OEOO_ORDR=" & forms!frmSelectOrders!OEOO_ORDR) 'To maintain a constant date to post...

Thanks for the response I guess I don't have a handle on this as I get a Compile Syntax error with this On Enter Event module Where OEOO_ORDR is a field in the referenced query. I am trying to make sure the form OEOO_ORDR entry is located in the query OEOO_ORDR field. Maybe you can point...

This has probably been answered before but I don't know the key words to get a search. I have a form textbox that updates a table. I would like to have something like a rowsource without the combobox to make sure a number doesn't get to the table unless it is in a field found in a specific...

Thanks, I will check that out and see if I get what I want.