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

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

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

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

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

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

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

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.

When I run this code to create a table with a PK I keep getting this error on the line where I have my contraint. Adding another parenthesis does not help. SQL Error: ORA-00907: missing right parenthesis 00907. 00000 - "missing right parenthesis" Any help is appreciated, Thanks!! CREATE...

I’m trying to set up a pop up window for quick viewing by double clicking a listbox value. I’m having trouble finding the selected value (Primary Key) and feeding it to the popup form. In the bolded code below "output_window" is the listbox. Error: Property let procedure not defined and...

Run-time error 2113 The value you entered isn’t valid for this field. The txtbox is unbound so I don’t think that’s the problem. The field value CFS in the table is a date and I’m setting CFS as an object so this is where I’m guessing things are going wrong. I can't set CFS as a date the way...

I'm running the query below to get a list but when I add the date function I get this error. The date function is supposed to get all the records that have been added in the last month. ORA-00936: missing expression 00936. 00000 - "missing expression" *Cause: *Action: Error at Line: 25...