Search results

I tried the above, but the form still opened in form view. Not only is the default view on the form datasheet, but I set all the other views to no. I'm leaning towards Dave's suggestion on handeling the error. So I've bypassed the issue by manually creating a form menu (instead of using the...

I've been trying that as well... Function Edit_Members2() DoCmd.OpenForm "frm_members", acFormDS End Function ...but then I get Run Time Error 2501: The OpenForm action was canceled. I get the sense I should be using error handling to resolve.

Yes. I have no problem when I cancel the query when I've directly opened the qeury. However, I use the switchboard so that users not familiar with access don't have to go to the database window. In fact, I have the db window hidden on start up.

Hello; I have a table that contains members (tbl_members). In this table I have a field for member ID (memid). I have a query (qry_members) based on the table. The query has parameters on the memid field so I can query for members by member ID. On the switchboard I reference the below...

Hello. I have the below from a consultant a few years ago. It exports a report and names the report to include today's name. So today's file would be "TODAY'SFILE 07-14-2009.snp" ------------- Function Export() Dim strdate As String Dim stAppName As String strdate = Format$(Date...

Thanks Doc. I can definately see how I was barking up the wrong tree trying to set the required property. I'll keep your tips in mind. Thanks again.

Here's what I ended up using. Private Sub Form_AfterUpdate() If [Source] = "PCA" And IsNull([PCA]) = True Then MsgBox "You selected "PCA" as the Source, but did not enter an ID in the PCA field. Please enter one.", vbExclamation, "PCA" [PCA].SetFocus Else: End If...

Hello Coack. Thank you for the correction on fields v. controls. Just a few things... -I can't make the field in the table required because it's not always required, it just can't be null when a certain selection is made on another field. -The above code will always give me a warning if I leave...

Hello, Seems like this should be simple, but can't find anything that helps. I have a form with three fields: Field 1, Field 2, Field 3. Field 1 is a dropdown list/combo box with values "A" and "B" as options. Rule: If Value "A" is selected in in Field 1, then Field 2 must become required...

Hello all. Resurrecting as I have a similar need. Thanks for any insight. BTW, Here's what I'm using. DoCmd.OutputTo acQuery, "QryCIUSRs_21_day_forecast_summary_Crosstab", "xls", "\\nas2share3\Share3\Customer Services\CIU\Common\Business Analysis\UCSW Inventory History\2009\CSC 21 Day SR...

Hello all. I've just inherited an Access database that has a macro with about 50 steps. This macro might run for almost an hour. I'd like to kick off the macro and go about my business, while looking back every few minutes to see at what stage the macro is at. However, all the status bar at...

Wayne, I tried your second suggestion, but again no results. Just so I'm clear, you're saying that if I identify and eliminate the carriage controls in access, the records will straighten themsleves out, right? I've been focusing on finding them in the text file. I was able to find a site site...

Thank you Wayne. No go on updating the table because the data is already imported and all the Chr(13)s have been converted into new recors (so they don't appear in the comments.) I had tried searching for chr(13) in the text file, but the find fearure wasn't identifying them ("Not Found".)...

Hello all. I've tried searching the forums as well Google for an answer for my problem, but perhaps I'm not searching on the correct key words. Would someone please point me to a post that addresses the below issue. My company has a customer service (CS) application where our CS agents...

Thank you gentlemen, I agree that it doesn't make sense, but the user is happy!

qafself: Thanks! After quick testing, it looks like it works. I see how you're referecing 60 days as zero %. However, this formula will be added to an existing report, so the "Days" colomn may not even contain a cell with 60 days let along 60 days in a fixed cell. However, I can add that...

Hello, I have a user that needs to measure timeliness based on number of days where 30 days = 100%. For example, if the number of days is 0, then score is 200%, days 15 then 150%, days 30 then 100%, days 45 then 50%, days 60 then 0%. Assuming # of days is in A1 and Score is in A2. I'm stumped...

Hello, I have an Excel file that I use to enter data. About half the columns are validation cells to minimize human error. The validation cells are in rows 2-200. I then import the data into Access. The problem is that, even if I only enter or select data in one row, Access imports all 200...

I never followed up on this. I guess I found other options. Glad you brought it up, though, I think I'll start looking into it again.

I'm trying to open a form but get the following message. "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." with an "OK" button. I know for a fact that no one else is in the db (it's on my hard drive)...