Search results

Haven't I done that?

it can be a simple test.i'd like to count how many times a person performed a procedure and how many times he assisted at it. table procedure, columns main and assist. Mostly same person appear in both coloumns, though occasionaly one can only appear in one of them. i have a list of ppl in a...

I'd like to count how many times a person appears in coloumn A and how many times in coloumn B some like this mike 1 4 rose 3 2 etc... how can i do that should i even use query for this or would report with some vba work better?

i found an old forum post it's a bug in acces 07 that was fixed in 10 there is a workaround, i had to export it to xlsx form and it works normally

i have problems with saving data to xls as it turns some characters in gibberish čšž goes to Cyrillic letters Љж... the rest looks rather normal... i'm not really sure Cyrillic letters are the right ones i use this line DoCmd.OutputTo acOutputQuery, "koordinator", acFormatXLS, strpath, False...

I'm sure it can be and that I'm doing something simple wrong. I get either just numbers for subgroups or just the totals. Guess I'll have to add an expression to add subgroups. another thing, same names appears in two coloumns, how can i get the number of times it appears in each coloumn? it...

i mastered (in the most broad meaning of the word possible) tables and forms, moving on to queries. I found out that getting reports is a bit more complicated then i thought and I'm just a little step away from tossing it all away and write a code in vba, but I think this should be easier...

yeah, works just fine like this Public Function LeaveCaps(strInputText) As String On Error GoTo ErrorHandler Dim strModifiedText Set dbs = CurrentDb Set rst = dbs.OpenRecordset("tblExceptions") 'Do the initial conversion to mixed case (initial letter capitalized)...

i think i can do it easier with replace in a loop is replace, and tables, case sensitive?

http://office-watch.com/t/pda.aspx?a=1176 it should leave L1 as L1 but it changes it to l1 basically it just does this UCase(Left(strInputText, 1)) & LCase(Right(strInputText, Len(strInputText) - 1))

I'm trying to convert text to sentence case, ie capitalized first letter of the text box. The input will always be just one sentence, so I just converted everything to lower case and capitalized the first letter. The problem begins here, I want some special combinations be left as upper case...

that part is left out for now, ie i get error if i say no, should correct that i might have found the solution, mistake, as I didn't limit values to the list i think it works for a bound box if i do that without a requery tx

where? i tried that a nothing really changed and it's not necessary for an unbound box

& vbCrLf & this should work MsgBox "" & Me.txtTlog.Value & vbCrLf & Me.txtIDD.Value

ps - i could probably add an update sentence in after_update event to go around this...

i have main table called patients, and a form PtEntry I have only bound textboxes and comboboxes there, so the data is entered separately I guess I could make it unbound but that would be a lot of unnecessary work and would cause some problems. I have a separate table called misc, where I store...

No error I can't even write it as it's to long for the editor and if i try to break it into lines with underscore it turns red.

i have a stupid problem i have a long sql where i insert into database 30+ values it's to long for the editor (line to long) and if i try linebreaks _ it returns an error. what to do :(

i have a form that has data from table 1, where i select a person and table 2, where i select an event i need to duplicate data, as simply editing it would make a mess and really complicate things, so it's much easier if just make a new event. I tried this code DoCmd.RunCommand...

sp. - special, sorry. I created query in place of report and just exported it to xls