Search results for query: *

Hi, When clicking 'Make' under the 'File' menu to compile my project as an executable, the file name always ends in ".exe" is there any way to have the name of the executable for example 'ABC' instead of what I am getting now 'ABC.exe' I know the file is an executable, but how come my actual...

Hi, I am trying to capture/copy a line of text from a Word document into a TextBox. Eg, Line 6 of Word file "C:\ABC.Doc" into TextBox1 Line 9 of "C:\ABC.Doc" into TextBox2 etc... is this possible? Ken

Hi, A beginner question. I have made a small project that does a few small calculations based on user input into a TextBox. The variables change once every financial year, is it possible to have the variables in a text file (Word, Notepad etc) so that my code will look at the text file for the...

Hi, I am pretty new to XML and was wondering how I would go about doing this..... THIS IS AN EXTRACT OF WHAT I HAVE GOT AT PRESENT <?xml version=&quot;1.0&quot;?> <BatchRequest004> <header> <system>CCeS</system> <timestamp>20040228124525</timestamp> <userid>NWAR-X004</userid>...

Hi, I have a project using VB6 where On Change of Text1.text a calculation is preformed. The TextBox is defaulted to &quot;0&quot; and as the user enters figures into the box, the calculation is done, but my problem is if the user clears the TextBox, they get an error message. How Do I get...

Hi, I am a newbie, using VB6, When I use the VB Application Wizard to try and teach myself a bit about Databases, Using the NorthWind Db as the record source, I keep on getting an error &quot;Compile error - User-Defined type, not defined.&quot; with the following line highlighted in the code...

Hi, In the following example of a Login form's code is there any way for me to prevent the form from closing if a user has entered an incorrect password or user name. I want the form to remain, so that the user can try again! (This is not my own form or code) Private intLogonAttempts As...

Hi, Is it possible to rotate field headings in the header section of a report...for example, can I rotate certain (not all) headings at a 45 degree angle (to save on space) Ken

Hi, Is it at all possible to format a report so that it does not have individual pages, but just 1 long report? Ken

Hi, I am using ..... DoCmd.OpenReport rptRen_Wait, acViewPreview DoCmd.RunCommand acCmdZoom75 To try and zoom a report called rptRen_Wait to 75% on opening, but am getting the following error.... Run-Time error '2046' The command or action 'Zoom75%' isn't available now. Can anybody tell me...

Hi, I don't know if this can be done, but here goes.... I am trying to make a roster of sorts, whereby I need to insert a name into a work position for a day. 1 row would represent a day, with columns for each position...eg Bay1 Bay2 Bay3 etc etc I want to have a ComboBox to choose a name...

Hi, I have a query that gives me the weekday number for all the weekdays between 2 and 6 (Mon to Fri). So these will all be under the field Expr1...as follows Expr1 Date 2.......6 Jan 2003 3.......7 Jan 2003 4.......8 Jan 2003 5.......9 Jan 2003 6......10 Jan 2003 2......13 Jan 2003...

Hi, How can I get a total for a field in the footer of a report. FIELD_A FIELD_B FIELD_C 3 19 5 7 11 1 9 15 10 4 2 7 6 1 5...

Hi, Does anybody know how to password protect a single tab on a form with multiple tabs (pages)? Ken

Hi, How come, when I build a form and want to activate a Delete Query with a button, all my queries ie... Select, append, etc are made available to choose which one I want to apply to the button are shown, except for my Delete Queries..why are they not in my list of queries in the button wizard...

Hi, I have 2 Action Queries, that I need to run on specific dates each year, query 'qryA' needs to be run on 30 June each year and query 'qryB' needs to be run on 31 December. Is there any way that this can be done, and if the database is not opened on either of those days, would it be possible...

Hi, Is this at all possible, I have a table that I want to use for 7 months, after which I want all records from all fields except the Key Field deleted, so that 'fresh records' can entered. So on a given date 7 months in advance, I want all fields except the key Field to be cleared. Ken

Hi, I am trying to make an employee leave roster. I have 12 tables, 1 for each month, 1 column with employees and 1 column for each day of the month. Is it at all possible to use 1 form to enter data into any of the tables depending on which month an employee requires leave, or do I have to have...

Hi, I am trying to build an expression (Conditional format) for.... If &quot;Period&quot; = 1 week and &quot;TodaysDate&quot; - &quot;RentalDate&quot; > 7 then the &quot;ReturnDate&quot; field must be say red. So if the field called 'Period' contains 1 week and today's date minus field...

Hi, I have a form that shows rental information, a person can rent an item for either 1 week or 2 weeks. Is there any way that the background of a control can be changed ('ReturnDate', which would have no entry at this stage)when the rentals period has expired. The form has amongst other details...