Search results

Maybe i confused you earlier when i had a image of a report with the escorts names in red...that was a photoshoped image to show you the result i wanted....sorry Here is the relations diagram: Im not sure how i would do the relation between the Escorts table and the InmateProfile one.... as...

Re: Error promt.... well...you are probably right boblarson. When i found the code snippet i was searching on how to overwrite a file that existed on your local drive so i could save my own from the attachment field. I just copied the code as "it" seemed to work and my knowledge on Access's use...

Run-TIme error '3021' <Unknown error/message> HRESULT : &H800A0BCDI get that on the red code when i try to run this: If Me.Photo.AttachmentCount <> 0 Then Dim db As DAO.Database Dim rsParent As DAO.Recordset2 Dim rsChild As DAO.Recordset2 Dim strFile As String Set db =...

hmm...well Ive been thinking and scratching my head now, have a bald batch to prove it :D I have no problems joining queries but how do i join a Table that has no linkage to anything else (and really cant be linked). The Escorts table is totally separated from anything else (just a list of...

You know you are right, tomorrow ill give it my best shot :cool: but don't sleigh me down if I'm back here late tomorrow asking again....how the heck i get one Query for the Inmates plus one user defined "selection" to look up values in another table and then lay-outed nicely in my report...

Sweet that was an easy way of doing it :D thx a million!

Well when the report is printed and they us it gather up all the inmates in the morning to head off to the different branches, the person responsible for telling which Escorts go to what branches will have a hard time figuring out what Escort is Number 3 or 4 or 5. :D So having the name printed...

Hi ya'll Im making tons of word docs and merging tons of values up to 50 a time... How would i make a null check like this simpler and maybe into a function?? If IsNull(Me!WifeName) Then .Item("WifeName").Range.Text = "------" Else .Item("WifeName").Range.Text = Me!WifeName If i dont do this...

Ok....uhhha :D finally....i've managed to make the "WHERE" string and it all looks very nice....but...here i go again... Q: I still don't understand how i will be able to extract the names of the selected Escorts and populate the right field in the report...sorry maybe im just a bit thick..:p...

ok i got the "comma" problem, just adding the single ' will make the string go into one column, but i cant still figure out how to ad a value to a specific column in an existing item in a multicolumn list box.... I did a workaround adding a second List box with one column where i add the...

I've go the EscortID string waiting now to be put in a hidden column....but.... I've been going crazy over this....first off if you addItem and its a string that has comma separated words to a multi column List box they (the words) get automatically put in different columns (ok i can live with...

Ok i checked with the "jail" and there will never be more then 4 Escorts per Branch that's why i have four colums for escorts. And Right now i have some functionality in the ListBoxes so if you select a branch you already Assigned Escorts for it replaces that item in the lower Listbox, just did...

Hmmm....let me just show you first how far i've gotten before i ask you about your suggestions... GUI operation: Well first you select a date, then you click "update branch list" ( cant get the dateChoser to do a form refresh on afterupdate...) then you can click "Preview Hearings schedule"...

Done with this: SELECT tblInmateCases.BR, Count(tblInmateCases.BR) AS Total FROM tblInmatesProfile INNER JOIN (tblInmateCases INNER JOIN tblInmateHearings ON tblInmateCases.CaseNumberID = tblInmateHearings.CaseNumberID) ON tblInmatesProfile.InmateID = tblInmateCases.InmateID GROUP BY...

Well that was that, thanks and i'm amazed at how basic some problems seem when you have solved them. Thank you immensely!

Hi, I get this result: from this SQL string: SELECT tblInmateCases.BR FROM tblInmatesProfile INNER JOIN (tblInmateCases INNER JOIN tblInmateHearings ON tblInmateCases.CaseNumberID = tblInmateHearings.CaseNumberID) ON tblInmatesProfile.InmateID = tblInmateCases.InmateID WHERE...

Actually this would be even better when it comes to overview for the user assigning Escorts so the user knows how many Inmates are going to the specific branches... Well now the tricky part how do i accomplish this... 1. query for the branch listbox with Unique values and subTotals per BR...

Is this how you mean? if its not it would still be a nice way of assigning escorts. If you want to change the already assigned escorts you would just select the escorts and then branch and click the assign button again and it would replace previously selected escorts for that branch...

Well hi there again :) feels almost like i should put you on a retainer.... Your suggestion sounds perfect...but now i changed the structure a little, not a lot though. Now I open a form (scheduleChose, refered to as mainForm before) with a select dateTextbox then a button "view schedule"...

Hello....again...y'all :D I have a structure question... Base: I have a small sweet query that makes a recordSet.This query gets a list of records corresponding to a specific date, *Some of the records will have a field (BR) with the same value, the recordSet is sorted according to this field...