Search results

CHAOSinACT, don't really know what your intent is with the spreadsheet, but sounds like you're linking it for no reason? You *just* want a couple of cells' worth of values? However, that being said: you're doing sounds similar to what i'm currently working on. I've had quite a bit of progress...

Thanks, i'll try it out tonight. Gotta get back to work as i'm now doing this in my lunch breaks :-/

Ta. That seems to do the trick. :-)

also, how can i get access to 'close' the xls file properly? i.e., so that when i go to my task manager, i don't see as many instances of Excel open as i have times tested the code! (and probably for other considerations i've not thought of....)

ok, i've had a go at starting on this and haven't got very far, LOL. at the moment i'm starting from the basics: find a cell with specific value, then grab the value from the cell immediately to its right (according to the current excel structure, described at length in previous posts - see...

have you tried using .Open instead of .Activate?

are you able to view the field code int he form fields? (try right-click, edit (or view?) field codes...), and see what it has there. maybe you can refer to the field itself rather than the forumla (ie., instead of calculating current date, use a formula to say fldDate - fldDOB) sorry i can't...

Sorry, my bad - i often forget to check where the thread is in the forum (Word, Excel, VBA.....) and often default my perspective to Access. What version of word are you using? In 2010, you can insert an autoupdating date filed by clicking the insert ribbon, date and time, select a format...

from what little i know about access and word, this does makes sense. i just wish the 'easy' way was preferred.... :-/ thanks HTC. i'll look into implementing this. the possibility that i might want to merge just one record with this database is quite high - don't want any issues, especially if...

ok, figured it out. i had to connect the two using the DDE option, which in the list states it's for *.mdb and *.mde files, even though my database is an *.accdb, this option works :-) go figure.

not been so whizz bang for me, i'm afraid. i'm trying to set up my first ever mail merge and it's not going great... as a start, i can't get word to recognise any of my queries within my database. attached is the process i'm undergoing. can anyone see where i'm going wrong? i can't seem to find...

No worries - this is all a little inherently messy. I don't think the machine software was ever intended to be transfered from one source to another. The normal use of results in a clinical setting is to print the report, then ring the doctor/clinician with results. However, we're using it for...

no no no, people aren't manually typing the excel data - they're manually exporting it from the machine which runs the test. the excel files are 'standard' but when there's no data for a particular heading, the machine doesn't include the heading itself. annoying, but not fixable. the data...

you didn't sound cool or accepting of anything. sounded like you left in a stomp. as for two month old post - the internet knows no time - i did a search online and this thread came up. for me it was only a few minutes old. i can find solutions to projects i tackled several years back. you may...

oops, there's been an misunderstanding/miscommunication. it's my fault for using the term "non-normalised"... if you look at the sheets, it is actually 'normalised' by way of new data on a new line... but it's all over the shop. also, i'm not understanding: how does putting everything on one...

Sure. What i've done is arranged the relationship view with the relevant tables. Basically anything with "MIC" in the name. Please bear in mind it is still a work in progess, so don't be shy to voice any major (or even minor) database faux pas you spot. I suppose i should now explain some of...

Hey everyone. Intro I'm going to tackle an import procedure i've been avoiding for a while - mainly because i have no idea of where to start with this. Please open the attached PDF (the files are excel, but i've printed to PDF for convenience of showing you guys) so you know what i'm talking...

hey guys, i'm trying to get an unbound form working and i'm getting the "Error 91: Object variable or With block variable not set". it's related to this thread because the error occurs when i try to select a record to go to from a listbox on the unbound form. the find record code is fine...

it is considered good forum etiquette to post your solution when you find one. also, we're not backing lagbolt simply because you are a newbie. we're backing him because he is right. The more you help us, the more we'll help you. if we can't read your code easily, there is less possibility...

found a solution for both me and mafhobb! i ended up adding a .FindFirst to my code, but you have to prefix it with a .Recordset, mafhobb: With Forms(strForm) ![lstPatients].Value = Me.lstIsolateSearch 'highlight correct item in listbox .Recordset.FindFirst "PatientID =...