Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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 =...

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...

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...

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...

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...

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!

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...

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...

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...

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...

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...

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...