Search results

I’m creating a small database to store some peer review records. I created two tables Practitioner (One) Peer Review (Many) On my form I have an IDNum field as a mandatory field to prevent duplicate practitioners from being entered. I wrote some VB to check for the IDnum field to match it to...

I searched the forums and noticed a few that might help but I’m sorry my SQL isn’t strong enough to solve this. I’m having a hard time trying to get this query to pull exactly what I need. Keep in mind SQL is not a strong point for me so I apologize if I’m not making sense. I’m looking for...

Thanks Wayne your post lead me in a direction for a solution. It ended up not being a coding issue but when work issued us new computers they had the tnsnames files in teh wrong folder. Adding this to the correct folder fixed the issue.

I wasn't trying to be rude its hard to convey emotion when posting quick responses to forums replies :)

We're using win7 not win8 and all Access 2003 applications work on it just fine the only issue is the ODBC connection to the Oracle DB.

Having a hard time figuring out why I get this error in win7 but not winXP? There is an MS Access application that is using the connection string below. A few of our employees have been moved to win7 and are reporting this. ERROR ORA-01019: unable to allocate memory in the users side CAUSE...

Thanks for the response I'll find out!

Thanks for the response. I actually checked the tnsnames file and added in the connection string that's needed. I was even able to create an ODBC connection on the machine and it tested correctly. I was hoping it was just that Win 7 is more locked down then XP and people were having similar...

We’ve been using this DB for years now on Win XP; we are being switched out with new Win 7 machines. For some reason this code below gives me the following error in Win 7 but has been working fine for years in Win XP. connectStr = "Provider=msdaora;Data Source=HIDW.WORLD;User...

Solved! Thanks bob you're a life saver.

I have a report that I want to run from a double click off a list view. The message box shows the correct value when double clicking but when the report pops up it only goes to the first record. It does not go to the record I've that column(0) is assigned to. Private Sub...

The second link was exactly what I needed, thanks.

First I know catagory is spelled wrong but that's how its spelled in the DB. I have 2 combo boxes, the first is a cbo_catagory the second is cbo_topic. After update of cbo_catagory I want cbo_topic's value to be based off what was selected from cbo_catagory. Private Sub...

Background: DB created in access 2003, my work upgraded to Access 2010. Now when I open the DB in 2010 and try to filter by form the "Filter" button stays inactive. Basically on my form i select "filter by form" then add a number into the field I want to filter. The apply filter button stays...

For simplicity on the querying side, we have a few people in the office including my boss who like to think they can do it themselves but they dont realize the effort on my end to make them feel tech savy.

I'm using Access 2010 and I’ve tried 2 different methods to get my radio button to insert text instead of numeric 1 or 2. This does the same thing with onClick and AfterUpdate. METHOD NUMBER 1: This works but the radio button stay “grayed” out, they do not check off when clicked...

Thanks everyone!

I have two if statements below, is anything returns null on the first if statement I want it to stop and proceed to the form. But as is both if statements run and I end up on the nutrition screen. If IsNull(Me.Catheter.Form!Combo81) Or IsNull(Me.Catheter.Form!Combo58) Then MsgBox "You...

Problem solved! Private Sub btn_OpenUTI_StageTwo_Click() On Error GoTo Err_btn_OpenUTI_StageTwo_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "UTI_Main" stLinkCriteria = "[patID]=" & Me.patID DoCmd.OpenForm stDocName, , , stLinkCriteria...

I have a button on a form that opens a completely new form. What I want it to do is open that new form with the current forms record source ID. I know this works from from to subform. Forms!UTI_Main.patID = Me.patID I hope this makes sense, thanks.