Search results

terces, unfortunately i don't think i can help. i spent about an hour fiddling with your database trying to get this to work, but there are two things i've never used before which prevent any progress: split forms; and macros. the master/child properties in a form/subform scenario...

it could be happening because you are closing the agency list form after you open and filter the project form. thus the project form has no way to reference the ID anymore because the referring form is closed (which is where the macro is that knows which ID is which). one way to avoid this is...

the other thing you could do, depending on how your excel spreadsheet is used, is link it as a table in access and simply run a query on the relevant fields. let me know if you need help with this avenue.

so where are your patient details?

your patients should already be in a row... do you mean you want each patient listed only once? as in, unique values as you would in access? to get a quick-n-dirty, from this excel example, after filtering i'd select the patient column, copy/paste into a new sheet then "remove duplicates" from...

this is not going to be a problem - all the data in the table will filter along with your selection, just make sure to have ALL your data selected when you make the table.

ok, see this visual guide in Excel 2010 (should be same/similar in 2007). just a quick mockup for you so you can continue in your work. read it from left to right, top to bottom. this is a great way to filter/sort data i excel without messing up the 'records' (i.e., doesn't mixup rows when...

let's start with basics: what version of excel are you using?

easy one first: firstly i assume you have the correct master/child properties set for your subform. next i would suggest you use a DrugInfusionID combo, with two columns in the source query but have the first column hidden (size 0cm). this ought to save the FK number in the table - currently...

is this data currently in excel? make a 'table' out of these excel cells and use dropdown options in each header to hide/display relevant fields. you can create a 'table' in excel by using the 'table' button in the 'insert' ribbon if you're using excel 2010 (i think it's the same in 2007)

Settings in acrobat? i use a different PDF writer, but in mine i can set, just like printer settings, what the definitions are for my PDF creation (e.g., black/white, paper size etc)

Also, in (a) you should be filling the autnumber primary key, not the text field from that table. i.e., SELECT tblColor.ColorID, tblColor.ColorName FROM tblColor. your foreign key field should be number, not text. but you should be using three separate tables, as plog urges.

have you set the child and master properties correctly? your foreign key should then fill in the subform automatically without the need for extra coding.

rather than making a complex query, why not code the button itself to apply a filter if the date fields are used, and none if they aren't?

ok, so you have some reports already which are showing in the form already - so can you redefine your problem? are you getting error codes etc? what IS happening? I can't imagine an MS sample database being "locked-out" - have you tried the SHIFT trick (hold down the SHIFT key while the...

what are you browsing? usually, "browse" indicates that you want to open a "browse for file or folder" dialog. yet your topic is for a path TO a subform control. Depending on what you want, these might help: Browse for folder/file API...

In terms of medical data, the only major requirement is to have de-identified patient details - that is, NOTHING that can identify the patient from that electronic source (this is especially important if the database is held on a server - even more so if the server is external (i.e., not a...

Hi Aron, i've just sat down to look at this properly. i would strongly advise against using separate fields for test date and test hour - this will make it harder to calculate your "time, in hours" since first test. I would also advise that you have a separate table for your test types, this...

Have you revisited this organisation since John Big Booty advised on normalisation? I'm concerned that you are saving these data in separate tables in order to display the data "like in excel"... are you happy to have the data saved in a better way if we help you? also, i think i know what you...

Hi Aron, can you please clarify what you mean by "count which hour that date corresponds to"? it seems that each measurement is at an arbitrary time (i.e., not always at 12pm, 3pm, 6pm and 9pm but varying) and surely the date can be entered manually or by automatically applying the current date?