Search results for query: *

Hi, We have an old computer (~1989) that is used to control an automatic test station. The hard drive crashed and we are trying to restore everything from a backup on magnetic tapes. The tapes are approximately 3 1/4" x 2 3/8" in size. The tape backup drive in the computer is labeled 250MB...

I have an array that contains a char that represents a hex number. The array might look like the following: stimByte[0][0] = "13" stimByte[0][1] = "FB" stimByte[1][0] = "FC" stimByte[1][1] = "53" The hex data is: 0x13FB 0xFC53 I need to convert the char array to hex data. I tried the...

Hi, I wrote two DLLs. One is called by a single application and the other is called by multiple DLLs. For simplicity, here's how they are named. prg.exe - Application a.dll - DLL that I wrote, called by prg.exe b.dll - DLL that I wrote, called by prg.exe and a.dll b.dll contains five cpp...

My form has controls on the left and right side. When a specific option button is selected, the controls on the right side are hidden and I want to resize the window to eliminate the empty space. I tried Form.WindowWidth and Form.Width but neither work. The former returns an error ...can't...

Hi, My form has a Microsoft Date and Time Picker control on it. The control is initially disabled and is enabled when a specific option button is selected. As soon as the option button is selected that enables the Date Picker, the date appears in the upper left corner of the form instead of...

Hi, Is there a way to change the name of a Control in a VBA program? I have the following: Dim itm As Control Dim oldName, newName as String For Each itm In Form.Controls If itm.ControlType = acOptionButton Then oldName = itm.Name newName = Left(oldName, 2) & "p" &...

Is there a function that returns True if a variable evaluates to a valid Date and False if it isn't a date? I remember using such a function before but can't find it in the Help. Thank you, dz

My form opens a report based on the selection in an option group. The user can select from one of many reports. Another option group on the form allows the user to direct the output to a screen preview, printer, or Excel. One of the reports requires two different RecordSources. The...

Hi! I want to create a report based on the following Query: SELECT tbl_LRU_Repair.LRU_Repair, tbl_LRU_parts_replaced.PartID, tbl_LRU.LRU_Name, tbl_SRU.Part_Name FROM tbl_SRU INNER JOIN (tbl_LRU INNER JOIN (tbl_LRU_Repair INNER JOIN tbl_LRU_parts_replaced ON tbl_LRU_Repair.JobID =...

Hi, I created two Queries that contain a date field, and then combined them into a Union. Each individual query displays the date field in Short Date format (MM/DD/YYYY). The Union query displays the date field in General Date format (MM/DD/YYYY HH:MM:SS). I want the date in the Union query...

I created a Form that displays revision notes for a database. It has only labels and a button to close the form. The form has vertical scroll bars because it is too long (high) to fit on the screen. The close button is at the bottom of the form. When the Form opens, the text at the bottom of...

Is there a way to set the Form Properties so the form's border looks like the BorderStyle is set to Sizable, but the user can't change the size of the form? Thanks! dz

I have three tables. Call them A, B, and C. Table A has a primary key named JobID. Tables B and C are related to A by JobID. How do I write a Query to return all records in B and C that don't match a JobID in A? For example: Table A has records with JobID = 1, 2, 3, 4, 5 Table B has...

Given the following Query: SELECT qry_convert_allJobs.*, qry_convert_parts_replaced.Part_Name, qry_convert_parts_replaced.PartSN FROM qry_convert_allJobs LEFT JOIN qry_convert_parts_replaced ON qry_convert_allJobs.JobNum = qry_convert_parts_replaced.JobNum; Here is each Query by itself...

Hi! I wrote a Query whose results might look like this: Part Number Description 123 ABC 1 456 ABC 2 789 ABC 5 873 ABC 10 329 BCD 2 234 BCD 3 897 BCD 21 The Query is: SELECT tbl_X.PN AS [Part Number]...

I am trying to refer to the value of a control on a specific Tab control on a Form. The names of the objects are: Form - frm_AddJob Tab Control - tab_Repair Control on Tab - txt_job I tried various things that begin with Forms!frm_AddJob!... but can't seem to get it to work. Thanks for your...

Is there a way to display a message on the screen without waiting for the user to press a button before continuing execution? I want to display "Record saved" in a small window after the user presses the Save button on a Form, but continue execution so they don't have to press Ok in a MsgBox...

Hi! Here's a description of my table structure. tbl_jobs - jobID (primary key) - jobNum - dateCompleted tbl_LRU_parts_replaced - jobID (foreign key to tbl_jobs) - partID (foreign key to tbl_SRU) - partSN (serial number of SRU replaced) tbl_SRU - SRUID - description - partNum...

Hi, One of the controls on my Form is named cbo_LRU. Every time a propery of the control is referenced in my VB code, the VB editor changes the case to cbo_lru. I searched for all occurrences of cbo_LRU in the code and can't figure out why the editor changes the text to lower case after I...

Hi, Is there a way to list the Form(s) that Queries are used on? Thanks! dz