Search results

ive done another search on this but i cant find a thread on bolding dates any other URL's anyone's aware of?

Hi all, Just wondering whether the Access calender has conditional formatting where the day can be a different colour when a certain condition is met. Note that there'll be a condition for EACH day... I'm just brainstorming at this stage to see whether my idea can be executed... Basically my...

I've just done some brief PDF reading, and it appears possible to pass arguments between subroutines and functions in the same form...so you're really saying it's not possible between two different forms?

Hi all, I have a main form with a function called vbaPlayingTimes. I also have a popup form with a cmdClose button which closes the form. When this command is clicked, I want to execute this function (which is coded on the other main form), whats the coding to do this? P.S. I will have this...

Hi all, I have a listbox with values queried from a table. The table has a yes/no field that I want in the listbox, also as a yes/no check box. Is this possible? Cheers

nevermind...i think i found it me.activecontrol.....

Thanks Tim, much appreciated...I have another question however... I have 7 combo's that will all have the same Open/Closed options...thus I thought of using the one function for all "on got focus" events for all 7 combos...theyre called me.cboSunday, me.cboMonday etc So as their names differ...

hi gemma-the-husky i'd like to have both a) and b) for a) bookings are for league players only and all rates at all times are the same for b) there are no points for individual players so far...just teams i think we mean the same thing when you say league and i say division....there are...

Hi all, I'm placing some combo boxes onto a form, and I need just an "Open" or "Closed" option available for users to select. Can I have some help with the coding? I'll be using this code at the "on got focus" event of each combo. I was thinking I could create a table with just "Open" and...

Yeah I'm sure both of you's have helped many readers with this...cheers to both of you's

Hi all, I've deleted the previous relationship images from ImageShack without realising that it'll remove them from this thread too. Good news, the relations havent changed much despite excellent help from you guys...here's why... By f22a at 2008-11-11 Since last week I've been stuck at how...

Hi all, My current DB has forms with logos used with custom fonts. By custom I mean I found a nice looking one from the web and I'm using it. Later down the track when I finish my DB and have it implemented, am I going to have to copy the font to my friends system?

Hi Mr Purvis, Thanks for your feedback. I've had a read and I'm having trouble understanding what happens if I had implemented your query. What happens if there IS a duplicate? This looks very different from an IF statement... :(

Thanks for the feedback HTH :) 1) OK you're the 2nd to tell me this, so I had more of a think about it. If I removed tblDay and the field tblFixture.[Day ID], you're right, I wouldn't limit myself to only the number of Day's in tblDay. I think I'd need to change tblFixture.[Day ID] to...

just an update for those interested By f22a at 2008-11-08

Hi all, I've learnt two different ways from this forum to get a value from a text box. dim txtBox as control dim strTxtBox as string set txtBox = Forms("frmFormName").Controls("txtBoxName") strTxtBox = txtBox.value ...and... dim strTxtBox as string strTxtBox = me.txtBoxName.value...

ahhh cheers! just out of curiosity though....if i had my code as follows... If IsNull(DLookup("ABN","tblEmployeeBusiness","[ABN] = " Me.txtABN)) Then 'there is not one goto function_end Else 'there is one End If function_end: am i just wasting programming space?

Hi all, currently I have the following INSERT query... strSQL = " INSERT INTO tblEmployeeBusiness ( [Employee ID], ABN, [Business Name] ) " & _ " VALUES ( Forms!frmEditEmployee!cboSelectEmployee, Forms!frmEditEmployee!txtABN, Forms!frmEditEmployee!txtBusiness ) ; " The primary keys...

lol i did a unit introducing databases at uni once upon a time but that unit doesnt make anyone an expert....only patience, experience and flexibility...im trying to make access databases a side hobby now... anyway 1. tblEXPAND will be renamed or tblFixture...i just couldnt think of a name at...

thanks again all :)