Search results for query: *

I have a challenge with a sales database. There are two tables: header and detail. Header has order_number and order_status, along with various other fields. Detail has order_number, line_number, line_status. The application is supposed to set header.order_status = 'C' when all...

Boy, that was easy. For some reason I couldn't find it in any of the refs I checked. Thanks!

I'm doing a data pull from an Oracle db to a .csv that I then import into Access. One field is a date; it's formatted in the table as mmddyyyy but I want to pull it as mmyyyy. I have this in my query as SELECT to_char(d.posted_dt,'MMYYYY') which works, but the column name then appears as...

Great idea - I hadn't thought of that! Thanks!

I don't even know if this is possible in Access, but I'll throw it out there. I have a text file containing an extract from a large mainframe db. Each record contains one 400 character field, and represents one of 3 types of data: CUSSMITH99999123MAINSTNEWYORKNY10011 is a customer...

Y'know, I'm torn between being relieved that I finally got the command right, and irritated that it was so obvious: DoCmd.RunCommand acCmdSaveRecord Thanks!

As mentioned above, you really want to split your database into a back end (containing just your data tables) and a front end (containing all other db objects). The back end is stored on the network, and each user has a separate copy of the front end on their PC. In Access 2003, there is a...

I have a table which users need to update via a form. There is a combo box which they use to select the record to update. The box has this code behind it: Private Sub cmbGroup_AfterUpdate() strGrpNumber = "SELECT * FROM tblGroups " _ & " WHERE GrpNumber = '" _ & Me!cmbGroup.Column(0)...

I have a form which synchronizes two combo boxes: the contents of box 2 depend on the selection made in box 1. This has been working perfectly, and I haven't modified anything in the form for several weeks. Today I opened the form to check something, and now the cursor will not move past box...

OK, got it... When I used the Expression Builder to add the fields, I was selecting from the 'Loaded Forms' tree rather than the 'All Forms'. Selecting the form field from 'All Forms' lets the dates appear on the report. Guess I need to understand an option before I select it. Thanks for the...

Remou - yes, I've used the Expression Builder to eliminate typos dhookom - no, I'm not explicitly closing the form - the OnClick property of the 'Run the Report' button on the form just opens the report.

I've added a label lblNoDataMessage, "No data to display", then set the form properties OnNoData, =[lblNoDataMessage].[Visible]=True

I have a form, frmReports, with two fields: txtReportBegDate and txtReportEndDate. I use this to pass the date parameters to the query that is the record source for my report. The query works fine so I'm sure the parameters are being passed. However, I want to use those parameters as part of...

The form displays data from tables B and C. My understanding (maybe I'm wrong) is that I can only use bound fields if all the underlying tables are included in the recordsource. I can't use tables B and C in the recordsource because then I can't update at all.

I have a form which contains data from 3 tables: Table A - the main table Table B, C - supplemental tables A is linked to B and C in one-to-many relationships. Because there are 3 tables with one-to-many relatioships, this is not an updatable recordset. I can view records but not add, update...