Search results

Well, no. ID is autonumber but txtID is a textbox and SerStatus is a yes/no field. This Code doesn't result in an error, thank you!

@cheekybuddha thanks once more, the new code now does exactly what i had imagined!! I just stumbled upon a new "error" message, which i have not encountered yet: For clarification: i got a button that updates the selected record's boolean status field, does a timestamp of the time it's been...

Sorry to take this one out of retirement, however i found the answer from @cheekybuddha to result in an error once i tried to apply it. Function UpdatedBy(ctlName As String) As Boolean Me(Me(ctlName).ControlSource & "X") = TempVars("UserName") End Function Dim ctl As Control For Each...

Hi, past few days i've been reading up on graph DBs in my spare time and i found it quite exciting. Has anyone here had any experience with those in a business enviornment? Also, anybody knows of any examples where a company would use a graph db for their day to day work switching from a...

Hi, i'm trying to export via vba to pdf, but i can't find a way to save print margins to be a default value, which would transfer to other machines as well so that it would always output the same file on any pc. DoCmd.OutputTo acOutputForm, "FormTEST", acFormatPDF, strPath & "\Report_" &...

I'm not doing a print operation, but rather ribbon>external data>more>word. I got it set to: Always.

Solved because switching to pdf..

Hi, is it possible to export a form header along with the actual contents of the form to word? This here is my test form (not the final thing) and i've been unsucsessful thus far with keeping anything but the form data, sometimes also the lines in between records. And here is the outcome...

@theDBguy @bob fitz @Micron Alright, thank you guys for the clarification. I've not been this involved in a forum before, so pardon my amateur faults. @cheekybuddha has provided me with an amazing answer on UA, therefore i mark this post a solved!

Is that a problem?

Hi, I've got a form for tracking repairs etc. done to PCs in our shop and i'd like to track who's checked a check-box. i got some 45-ish check boxes in there and i got a table column extra for each of these to store the data in of who did what, namely TempVars UserName, however, i figured there...

Happy birthday!

well, yeah, that's what i settled on.

Thank you! Is there a way to resize it back to it's original size without toying around with numbers?

Hi, I was wondering whether it's possible to change a form's width on demand. I got a nice form with a listbox on it and i was hoping i could make it expand, namely it's width to show more data within the listbox, but only if one so desires.

Hi mate, it's a bit obnoxious, but here's the only solution i managed to get working. So uh, don't have it as a value list, make a table instead where you will have your values, then open the design view of the table, select the column and in the properties menu on the bottom switch text...

it just always starts working whenever i set the bound column to the text one instead of the number one, but that in return breaks my code, rendering the combo box unusable.....

The note specifically states that this does not work with combo boxes but rather text boxes. i tried to enter that in my format property and it changed the text to this : sh"ort "d"ate";;;"<not scheduled>"

And now it doesn't anymore, i'm so confused.

OK, so i figured since the properties don't allow me to input ;;;"test" and none of the logical syntax works, i would just swap it around so that i would not be bound on column 1 but rather column 2, so i wen't from this row source ...