Search results

I created a sp. query, there's a lot of calculated fields in report, and i just export that query.

Tx. Works great, didn't notice any errors either.

great, tx Me.txt= Format(Date, "dddd, d. mmmm yyyy") is what i need

not sure i understand you mean that i format field in a table like that? hm, i have a table to store some values that i could use for this. I only need this monday, 25th of november displayed like that on top of a report, so i just use date to fetch that day. i could write it in a table first...

like in this example type something and press green '+ ie picture and it's null/previous if you press button it's whatever is in the txtbox is there a vba command to confirm whatever is written?

i solved this by simply inserting pcitures and adding on click event i have this situation now. i write something in the textbox and press image, the focus stays in textbox and the actual value is still null or whatever was written before, not is being written at that moment. if i have the...

i read about weekdayname issues here http://www.access-programmers.co.uk/forums/showthread.php?t=233212. And this solution works if i set first day of the week to sunday. Now i don't want to do that as we start weeks on monday and I guess most comps have it set like that. Now if I'd be sure...

I had similar problems with large tabs, modtly those with subforms on them). Setting focus in the top left control does the trick fir me.

I'm trying to save report as excel. first three lines look fine, then the third row keeps repeating till the end (the number of lines looks correct. Any idea? tx

It has to work on many different comps with good and bad screens

I got some icons in my access repport, next/previous, save, send mail etc. I used some icons from web, 128x128 pixels and shrinked them to 0.7x0,7 cm. works fine at home in access 2007. at work, also access 2007, i've got version incompatibility msg. All icons look huge, even if i reinsert them...

Now it works. Not sure what was wrong, maybe a different issue.

one more problem I'm trying to save to user/documents folder. i use this strusername = Environ("username") strpath = "C:\Users\" & strusername & "\documents\test.pdf" DoCmd.OutputTo acOutputReport, "Operacije1", acFormatPDF, strpath, True how do i format addattachement part .AddAttachment ""...

got a solution more or less .AddAttachment "C:\DL\test.pdf" now, do i have to save the report first, or can it make a virtual copy? more of an academical question really as this works fine enough

I use this to send email msgs through gmail found it on the net somewhere, adapted a bit and it works. Private Function fSendGmail() As Boolean 'Returns True if No Errors are Generated On Error GoTo Err_ErrorHandler fSendGmail = True Const conStrPrefix As String =...

well.... i do it like this, if you want a non expert solution if you have data for both comboboxes in one table set first box data something like this SELECT DISTINCT Predloge.TemplGroup FROM Predloge; create after update event for your first combobox that defines the source for the second...

so if I want to get just the ID of the record that I'll use later for other things then dlookup is good enough / or maybe even better? and if i want more values at the same time the sql is faster? how do you display results and work with individual results? do you need definitions of dao...

tx for help that worked well, and is so obvious now ;) proper sql.... ill look into that later the base will contain app 10000 records per year

cntr = 0 For i = 0 To stp - 1 t(i) = DLookup("[OpID]", "[Ops]", "[bID] = " & lkp And "[OpID] > " & cntr) cntr = t(i) Next dlookup is driving me nuts this works with only one criteria but returns type mismatch if I add the other criteria all...

I have a form where in the header i select record by selecting person by name, surname, date o birth. In the end there might be a thousand records per year. This part works well. Now I'd like to add a few checkboxes, that would limit the records range. A checkbox that would only select...