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 Chriss Miller 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: *

  • Users: childrenfirst
  • Content: Threads
  • Order by date
  1. childrenfirst

    Checkbox headache...

    Hi, I am sure that it's a simple question to all the experts on this site. I have a subform that is a continuous form which returns records from a SQL stored precedure. Each returned record has an associated checkbox,txtCurRec, in the subform. The checkbox's control source is set to be...
  2. childrenfirst

    how to pass the scope_identify value back to Access form?

    Hi, I have a stored procedure that runs after Access form passes the global variables to SQL. New records will be inserted into a SQL table at the end of the stored procedure and the primary key for the table is an auto-id. I would like to pass the auto-id inserted into this SQL table back to...
  3. childrenfirst

    How to display a "Timer" in Access as SQL is running in the back?

    Hi, I am not sure that this can be done in Access Project... I have a search form created in Access, and when users click on a command button, the event will launch the SQL stored procedure to search for results based on the search criteria. Search results will be returned to a different...
  4. childrenfirst

    How can I pass multiple values for a single parameter?

    Hi, I am not sure if it can be done. I have a form which shows several records. Users get to check the checkbox associated to each record if they want to delete the record. After users click on a command button on the form, the on click event is supposed to pass the ID number of any (can be...
  5. childrenfirst

    Is it possible to get the value for another form?

    Hi, I have two forms in the Access Project file. When I click on the command button on the frmMain, a value should be loaded into the other form, frmList. However, my code does not seem to retrieve and load the value into frmList properly. Any advice will be greatly appreciated! Here is...
  6. childrenfirst

    How to update control's value before running the stored procedure?

    Hi, I have a form which has two controls, txtViewReportNum and txtViewDescription, and a subform which shows results from a SQL stored procedure named s_ViewList. The problem with my vba code is that the string which execute and return values from the stored procedure always seems to execute...
  7. childrenfirst

    Execute stored procedure from vba Access

    Hi, I am trying to run a SQL stored procedure with the output in an Access (.adp file) form. Here is my vba code which does not work when it tries to execute the stored procedure... Any advise will be greatly appreciated! Private Sub cmdCreateAuditList_Click() Dim strRecordSource As String...
  8. childrenfirst

    Update trigger does not allow me to update the table...

    Hi, I created a trigger which will launch a stored procedure whenever an existing record is edited. The trigger looks like this: CREATE TRIGGER [tr_EditTimeOff] ON [dbo].[TimeOff] FOR UPDATE AS DECLARE @EmpName AS varchar(50) DECLARE @Manager AS varchar(50) DECLARE @RequestID AS int SET...
  9. childrenfirst

    how to convert these two dates?

    Hi, I have a table and every row of record has a column called ImportDate for timestamp in format like 2006-12-08 15:47:27.717. I created a query to convert timestamp into short date, but did not get the result I wanted. My query: SELECT RecordID, SelectDate =...
  10. childrenfirst

    how to convert this value into a stored procedure variable?

    Hi, I have a query and it works, but I am trying to pass a variable to the query and failed at this point. Original query (and worked!): SELECT Top 5 counter FROM Employee ORDER BY NewID() Try To (and did not work...): DECLARE @selectnumber AS int SELECT Top @selectnumber counter FROM...
  11. childrenfirst

    How to temporarily disable an event?

    Hi, I have two macros created for an Excel workbook. The first one is to update column AD in all worksheets in the workbook and the workbook is open (it's a Workbook_Open event). The second one is to show a popup message whenever any cell in column AD in any worksheet is selected (it's a...
  12. childrenfirst

    How to update all worksheets, not just the activesheet?

    Hi, I have a module in Excel, which will update the hyperlinks in column AD when a user downloads the spreadsheet and open it from his computer. The problem is that I want the macro to update the AD columns in all worksheets in the workbook, not just the activesheet. How should I modify the...
  13. childrenfirst

    Popup message in Excel

    Hi, I have a macro which highlights selected cell and also displays a pop up message when a cell is selected. My I would like to modify it so that it only highlights the cell and shows popup message when a cell in column, AD, is selected. How should I revise the macro I have? Here is what I...
  14. childrenfirst

    Display message box when clicking Excel cell

    Hi, I am not sure if it is doable... I have a spreadsheet and, in column AD, there are hyperlinks in several cells. I would liketo display a message box with some warning every time when users click on the hyperlink. Any advice will be greatly appreciated!
  15. childrenfirst

    Easiest way to send auto email from Access

    Hi, I have an Access form which contains a text box (txtUserName) a combo boxe (cboDept) and a command button. When users click on the command botton, values in the text and combo boxes will be passed to a SQL table. I would like to add another function into the VBA code (I only know how to...
  16. childrenfirst

    sort by day of week

    Hi, This is probably too easy for experts in this forum, but I just can't figure it out by myself... I have a query like this: SELCTE DATENAME(dw,[Date]),COUNT(*) FROM Dates, TimeOff WHERE DATENAME(dw,[DATE]) BETWEEN StartDate AND EndDate GROUP BY DATENAME(dw,[Date]) It returns results like...
  17. childrenfirst

    Macro to download the most current .adp to user's computer

    Hi, I have an application in .adp, but don't want users on the network run the .adp file directly. I heard that there is a way to create an .mdb file (no tables, forms, or vba codes, but a macro that download most current .adp file from the .adp file in the network to user's computer), and...
  18. childrenfirst

    Group by week days

    Hi, I have to create an Access report based on data in a SQL table. The table has four fields, EmployeeName, Timeoffstartdate, Timeoffenddate, and Offtype (there are two types: sick day, paid leave). The report needs to show which week days (i.e. Monday, Tuesday, Wednesday, and etc.) people...
  19. childrenfirst

    How to bind a subform to stored procedure

    Hi, I have a subform called Result which returns the search result based on the criteria set by users on the main form. I created a stored procedure which is executed correctly but returned no result because I think I did not bind the subform to the stored procedure correctly. In Record...
  20. childrenfirst

    AllowByPass

    Hi, I set up the Startup in Access Project so that users cannot get to the database and tables. However, I would also like to set up AllowByPass so that users cannot bypass Startup. I found some codes in Access Help and the Internet, but I have no idea how and where to add it to my...

Part and Inventory Search

Back
Top