Search results

I've managed to transfer data in a subform frm_WIP_Subform to C:\MyWIP\WIP.xls using: DoCmd.OutputTo acOutputForm, "frm_WIP_Subform", acFormatXLS, "C:\MyWIP\WIP.xls", True and this works fine. The correct data is transferred and the spreadsheet opens. However, I would like to apply some...

I have the following code snippet that opens up word document T163.doc from C:\MyTCN\ When the file exists it opens up. When it doesn't exist it throws out an error message box with a load of info and a Debug button. However, I'd just like it to pop up a message box saying "File Does Not...

I have a database application that i intend to split with the table part on a server and the forms part on each users desktop. It will be used by approx 10 users. While the probability of different users accessing and updating the same form is small, the possibility exists. Is there a way i can...

I've been working on a large project for my employer for a year now (but software development isn't part of my normal day to day duties). Most of the work (around 70%) has been done in my own time at home. The company were going to buy a system that would be customized by developers at a cost...

I have a graph called Graph7 on a form with the graph title set to XXX I have the following code in the Forms on Load event Me!Graph7.charttitle.Text = "AAA" but when the Form loads the Title doesn't change to AAA I've hunted numerous forums and tried the suggestions but to no avail When...

I have the following field in Query Builder Status: IIf(DateValue(Now())>DateValue([Expiry Date]),"Expired","Current") and it works fine What I would like, however, is to include the following condition into the above Status: IIf(DateValue([Expiry Date] - DateValue(Now()) < 2),"Nearly...

Hello Everyone, Thequery shown below is supposed to show the number of cells having a bin_value = 4 for each silicon_wafer_number. It does this except for when a silicon_wafer_number has no cells with bin_value=4 in which case it just doesn't displays the record (rather than...

I can create a recordset of labels from table test OK. What I then want to do (but can't figure out how) is to put each recordset value label01, label02, ... into a series of text boxes txt_label_01, txt_label_02, that are on a form... Do I have to fire the recordset into an array (or is it...

Dear All, I hope someone can help explain why i can achieve the following at design time but not at runtime. I enter text into a textbox txtEntry on a form frm_MainForm e.g. enter abcd then click a command button to execute some code with the following effect: A new column "abcd" is...

I have a subform datasheet that defaults to the first TabIndex field so the text is highlighted. Is there a way to remove focus from all my subform controls (they are all text/label pairs) or some trick workaround similar to setting focus to a transparent button (which isn't an option on a form...

Hi Everyone, I have 2 tables: tbl_lot lot_id (PK) lot process_step_id 1 lot-a-01 1 2 lot-a-02 2 3 lot-b-01 1 4 lot-b-02 1 tbl_process_step process_step_id (PK)...

I wondered if anyone could help as i've been at this for 2 days now: The following article 294202 which can be found by Googling "MS ACCESS ENUMERATE RECORDS" (sorry but i don't have enough posts to give the link directly) describes how to enumerate records in a form (which i've managed to...

Hello, This is my first post on this forum so sorry if i make any mistakes: I have a table with 2 fields: my_id (Autonumber, primary key) my_test (Yes / No) e.g. my_id my_test 1 No 2 Yes 3 No I've replaced the normal checkboxes with No...