Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TheComputerDude

    Date function returns null

    Here at work, we have proved that the CMOS battery could be dead and still have the correct time in Windows. How? Most networks have a timeserver that sets the time for computers if they get out of sync, so the CMOS battery could still have a role in this. Next, VB allows dates to be set as...
  2. TheComputerDude

    Automating Manual Access Steps

    I would keep the same table intact and do the delete script either right before you execute an append query (formerly your make table query) or when you are finished with the data. This will ensure that the table is clean when you put in the data. You can then do a record count and see if it...
  3. TheComputerDude

    Date function returns null

    I have no global variables and here is the code from the form. When in debug, I pointed to the line that I indicated with a --> and DATE was displaying NULL not the system date. Option Compare Database Option Explicit Dim strfilter As String Private Sub cmdButtonApplyFilter_Click()...
  4. TheComputerDude

    Automating Manual Access Steps

    Are you constantly creating the same tables? If so, you may just want to delete all the records from the table. Access has a bloating issue when you create new objects and then delete them. To do this, simply use the following: CurrentDb.Execute "Delete * from tblxxxx" Let me know if this...
  5. TheComputerDude

    Date function returns null

    I just encountered a problem where the built in date function in VBA shows that DATE is NULL when in debug mode. The NOW function still works however. Does anyone have an idea what might be causing this? I've never had this problem with the DATE function before. My thought is that it might...
  6. TheComputerDude

    Text To Columns

    The array dimension and/or size may change due to the data being displayed. I would like to be able to dynamically change the number and/or size of the fields.
  7. TheComputerDude

    Using Environ$("username") as a security measure

    You could try the following code on the ThisWorkbook module in Excel: Private Sub Workbook_SheetActivate(ByVal Sh As Object) If Sh.Name <> "Sheet1" Then If Not ValidSheetUser(Sh.Name) Then MsgBox "You are not authorized to view this sheet", vbOKOnly + vbCritical, "Unauthorized...
  8. TheComputerDude

    Text To Columns

    I need to dynamically convert parts of a spreadsheet to columns. I used a macro to get the following syntax: Selection.TextToColumns Destination:=Range("A7"), DataType:=xlFixedWidth, _ FieldInfo:=Array(Array(0, 1), Array(11, 1), Array(24, 1), Array(37, 1), Array(50, 1), _...
  9. TheComputerDude

    Referencing a query in code

    I prefer to write my queries in code, but I am not sure how to reference them from another query. I know FoxPro supports cursors, but Is this possible in Access?
  10. TheComputerDude

    MsgBox keeps switching forms

    Here is one option that you could use. On form1 do the following: Private Sub Form_Load() Form2.Show 'Opens Form 2 End Sub Private Sub Form_LostFocus() If Not blnFormMove Then Form1.SetFocus 'Keep focus on current form If MsgBox("Do you want to go to the other form?", vbYesNo, "Go...
  11. TheComputerDude

    Tables disappear

    The tables are listed. But when you attempt to click on any of them, all tables vanish. The tables do not reappear by changing from one DB object back to another.
  12. TheComputerDude

    Tables disappear

    I have an application that pulls data (1 table) from an SQL server. The problem is that occasionally the tables disappear. I mean both the linked table and all local tables disappear. Closing and re-opening the database corrects the problem, but I need this program to stay up and running...
  13. TheComputerDude

    Control Arrays -- passing controls as a variable

    I have 3 control arrays (text box, list box, and combo box)and would like to populate a form in 3 columns. I have never tried to use a control variable before and I am have a problem trying to get it to work. My code is below, if you have any suggestions, please let me know. Private Sub...
  14. TheComputerDude

    VBA Question

    You need to place a form text control on your document. Note: You cannot place a form text control in the header or footer, so you would have to place it on each page where you want it to print. You could then, place this code in the close event of your document or you could call it from the...

Part and Inventory Search

Back
Top