Search results

My first reaction here is to disagree with this advice. However, let's say you're right - in which case, how do you prevent data entry errors? Say, someone typing "AMD Int." and another writing "AMD International" and someone else writing "AMD Int. P/L"....? Queries on Supplier would then yield...

Well, despite my misconceptions about how buttons work on continuous forms, this solution actually worked! <p>This means the final setup is: <br>- conditionally formatted textbox underneath the other controls with no events and no binding. black by default, coloured on condition. <br>- black...

Yes, that's right. I'm using images in place of buttons, but they are also unbound and have the same limitations. That's right, there is no problem with my code - each button event works beautifully on the current record. Just as access wants it. Huh, when i bind my image 'button' to my...

Finally my internet has kicked in. The long-awaited image. (Look towards bottom right).

Hi burrina, While this is cool (i didn't know about Me.CurrentRecord), it still is using what Access considers to be the current record, not what a user might consider the current record. When i debug print Me.CurrentRecord to the immediate window, it returns the record number in that...

Thanks for your reply Burrina, the problem i have is that the ID is for the 'current' record in the continuous form - so, wherever the cursor is, that's the record ID it pulls instead of on the record that the mouse clicked over. So, let's say there are 5 records in the continuous form and my...

Hi, in my continuous form i have three images each with onClick events. when user presses one of these images, the code is executed for the 'current' record, not necessarily the one that the user clicked on. How can i make access acknowledge the record that the user wants? I have tried setting...

You haven't wasted anyone's time - this information is going to be very valuable to me very soon. I'm glad you posted your solution, as i'm sure others are (or will be) soon. :-)

patatrac, I have just gone back and found the database where i was trying to get this to work and am sorry to say i never did manage to get it to work. If you do discover a way, please post your success and details to the thread. Good luck! Agnieszka.

FillTo is not a method - "Fill" and "FillTo" are just (edit: ) rectangles (/edit) called "Fill" and "FillTo". Their purpose is to generate a progress bar (handy if the linking takes a long time).

Hi Khalid, It's been a long time since i had a moment to do anything database-y: i'm studying a Master of Teaching part time while i'm still doing my full time laboratory work. Doesn't leave much time for play! you can find me on FB using "Agnieszka Wiklendt". :-) (if you're still keen!)

prompted by tehNellie's answer, i have found two apps which look good for forum access: "tapatalk" and "forum runner". both work with vBulletin forum structures however both require the forum owner to register/activate their site (free) with the app provider. i cannot find, on either dev's...

no idea how to build an android app myself - is this on the cards for any bright development out there? :-)

OK, here's the phoenix node i have. last i worked on the database from which i extracted this was almost 2 years ago, so i had to remind myself a little how it all worked before i could remove just this phoenix portion. sorry about the time it's taken - hope this will still be useful to you (if...

Hi Aron. Sorry for the tardy reply. Wind back a sec - you're trying to select the Infusion name in what combo on what (parent?sub?)form? What do you want to happen when you select this Infusion record (add an infusion to a patient or to a regiment or other)? Yep, basically when you create a...

can't help you with the incrementation, but you can list all players names in a continuous form (or a subform in datasheet view). setup should be similar to your report.

Ha!! got it! what i did is added the Agency ID field to the Project Lists form and added "=TempVars!CurrentID" in the "Default Value". it now adds the AgencyID automatically :-) to do this, you also need to remove the "removeVars" part from the Agency Name macro. I would probably re-add it to...

the question is not whether you *can* create tables, it's whether you *should* create tables. this sounds like a normalisation issue to me, more than a coding one... can you perhaps explain why you want to create tables, then we can help you to find a better way to organise your data.

i have that kind of setup in one of my lab databases too - i use an append query behind a form command button (in combination with a set combo) to automatically add the set to my run so that the user can simply add the results, rather than knowing which tests are in the set as well.

if you want to see which users are either admin or teachers, just run a query with the info you want to see - there's no need to save the same data in multiple locations, as smig said, to do that goes against good database design.