Search results

well... maybe this is not what you are looking for but why not save the new label colour in a table and on load for the form look for the label colour for that particular label in the table. gives you all the control you could want for all graphical elements in your db.... Hope it helps...

hi guys, im revamping (redoing) a prisonInmate DB and i need guidance in creating the VBA for it. Data structure: The DB has inmates in 6 security classes (MinA, MinB, Med, Max, Rdc, Jasc) then they are divided into squads (A, B, C, P1, P2 etc) that mostly fall under one of the security...

Yeah i agree with you fully, but...haha there is always a but. Im starting to get a little lost now with how to actually make the relations work and display them. As i said before this is my first Access project and its starting to get a tiny bit complicated now. As an old flash designer i see...

If you look at the attached image, this was my idea..a intermediate table to link Inmates to Visitors...does anyone think this would work? The tblVisitorInmate is the intermediate table....

Ok, i get that. But the two sets of people are extremely different. One has about 40 fields and the the other only about 7. ONe set are inmate profiles the other is The inmates visitors. Would you still have them in the same table? Z

Explenaition: Im adding a feature where the user can add records in a new table (people2) that will be related to existing records in a table (people1). Basically im adding a feature with visitors to a db with inmates in a jail. The visitors can visit multiple inmates and the inmates can have...

well...well ...well...i had a notion when i went to bed last night and i just checked it out...I'm glad to say it works now and that it was a human error as 99.9% of all problems are. the backend db's field was not set on limit to list i had only set it in the control itself to limit to list...

Ok, Ill start my debug session...ill remove, recopy, redo any other "re" there is to see if i can get it to work :) Thx Guys

yep! all controls with value list don't react to an item not in the list, thats why i though it might be a thing where it doesnt work with value lists....

I have some comboboxes populated by the Value List option. When i set the "Limit to list" It still allows the user to input a value not in the Value list....? I use the same method for Comboboxes populated by a Query in that case the user gets the prompt "Not in the List" if they try to input a...

No Repaint didn't work or half works, as i explained before i need to do some kind of action after the repaint: Move another window above the access window or move the splitter bar (Spreadsheet) in the form or just move the access window a pixel and the changes are made visible in the form. The...

Well...it kinda works now, but i was hoping i wouldn't have to use the refresh command as it is already in the OnCurrent and there are quite some calculations to and from the backend for each record...so there is an increased delay now between browsing records....:(

I have but no update/refresh, but as soon as i move/Resize or do any other kind of action to the actual access window the control gets updated...hmmm very strange... There is no flicker of the form with the repaint action, but if i move the divider bar between the form/datasheet i get a flicker...

Hi All, Im setting the Visible property of a textbox depending on a value in a record (Archived = True or False) The Problem is that when i browse through the records it doesn't update the controls visability...or let me rather say it doesn't update. If i move any other window above the Access...

I think you missed the line: etalsDisplayRecordSet.Open , , adOpenDynamic, adLockOptimisticUp in the code where its open..i actually never close it..... * ill do some more debugging But the problem doesn't seem to be with the recordset(it gets populated and so on)....its referring to the form...

Well they have the same name, and yes i have tried renaming them differently with no success, and yes i did try the set keyword...so im at a lost but ill keep debugging thanks again Zozew

To comment your "off topic" as an old flash developer i was really surprised to see how VBA was being coded when it comes to giving variables values particularly string values. I understand the need to split them up because of the lengthy SQL strings but still. In ActionScript (Flash's native...

just to show the code: Red is the Dynamically created rs and the blue is the line i get the error on... Dim reportSql1 As String Dim reportSql2 As String Dim reportSqlFull As String Dim cnnX As ADODB.Connection Set cnnX = CurrentProject.Connection Dim etalsDisplayRecordSet As New...

Hi again...im running the code now and it seems to be populating the dynamic recordset.(did some testing) but when i try to assign that recordset to my form in the main Form with: Forms!InmateEtals.Recordset = etalsDisplayRecordSet It just error on cann't fin the "InmateEtals" form referred to...

Ok, so basically i've been doing early binding in my VBA coe until now...starting to undarstand the syntax. That's how i've been manipulating tabels data. Great thanks and ill get right on to it... :)