Search results

Hi folks. I'm a bit rusty with not using Access for a bit so I need your guidance. A friend of mine has caught wind that 'I've done a bit' and asked me to produce a Db to simplify his sales and manufacturing part of the business. Unfortunately, working in the NHS leaves me with no experience in...

Mornin' All. Does anyone know what has happened to http://www.msofficemag.net It had some great reference articles but it seems to have died? Does anyone have any other useful links that has good in-depth articles on Office development?

I could do with a little help here as I'm stuck. I have a patient information system and part of this is to record the patient's past medical history. These items are not set but they can be recorded via a yes/no response. Therefore I have tblPatientInfo, tblPMH and tblPatientsPMH...

I have 2 identical databases on 2 sites storing patient information but now they are networked, I can now access a shared BE on the network. How can I append all the data from one BE to the shared BE when I have linked tables eg tblPatientInfo linked to tblReferralInfo via PatientID...

Just created this for a friend (With a teensy weensy bit of code ripping) so I thought I'd post it here. Improvements and modifications always appreciated.:cool: *fixed* version

I am having real problems validating data on a subform. All the fields on the form are required (and is set as so at table level) But I am able to enter a partial record into the continuous subform without Access trapping this. I have tried setting each individual control validation rule etc all...

I am having problems converting my A2k Db to 97. I develop in A2k, the main user uses A2k but all else use A97. When I convert, a majority of the reports will simply not run or throw up an error (normally related to an on open event which checks the users security access before allowing them to...

I have something that is baffling me. I seem to have records disappearing from my Multi user Db (FE local, BE server). All data is inputted via forms with Allow Deletions set to No but records are just vanishing without trace. I have no delete queries, no VB code to delete anything but still...

How do you exclude a selection from a combo that has previously been selected in another combo? I am Creating a Soccer Db and using Combo's to select the team but each player can only have 1 position!. I have thought about using a separate query for eack combo, excluding all the other combo...

I work in healthcare and I am trying to produce a report to show both referrals and contacts for a given month on the same report but I am having problems structuring this. The report is sub-grouped by referrer and diagnosis but on each page I want to show the total number of referrals AND the...

I have a reports menu that can churn out reports for several time scales eg months, quarters , calendar year and financial year. I use 2 combo boxes. 1 to select the timescale, 1 to select the year. The timescale combo looks up date values from a lookup table ie StartDate and EndDate. These are...

Can Anyone help, this is doing my head in. I have a main form with 4 tabs. The main form is built on a query from 3 tables PtInfo, RefInfo and DisInfo. PtInfo is the main table with DisInfo and RefInfo linked by an integrity enforced 1:1 link. My problem is when I enter a new record, I can enter...

I have a combo box with 3 fields; ID, ShortCode and Name. I have the columns set to 0;1;2.5 so only the ShortCode and Name are shown. What I want is for the user to be able to type in the short code but the combo box to display the name. Can this be done?

I am creating an appointment system for multiple users, showing multiple diaries. I have a keydown event that indicates if a person has arrived, is being seen or has left using the Fn keys. I have 44 appointment slots and was wondering if there is a way to run the same keydown event on multiple...