Search results

Nevermind, trial and error has done the trick once again! Me.txtStats.Caption = TempVars(UserName) Just didn't know how to work with this object properly.

HI! I'm trying to have a little piece of text on my menu form which would display the currently logged in user. I handle the log in process via TempVars(UserName) but i'm unable to print it's values into text that would display on a form. Any tips on how to go about this?

Hi, is it possible to have my query pull data from the db and put it under new custom column names for the excel export? I have a db with shortcuts which are not exactly pleasant to look at by anybody but me and i would like to be able to export these under diferent names without actually hard...

oh i didn't know you released more of these, amazing, thank you! I'm toying around with your "attention seek" demo, it's been really great so far, at the moment i'm trying to implement your balloon messages. I thank you for that as well!

Hi, I stumbled upon this guide. And i also tried the method as described in the comments which is: But i didn't manage to get that running, when i try to put the VBA code into my opening forms on load event, it gives me an error, saying "ribbon" is not valid. So my question: is there another...

Hello, I'm struggling to find a good guide on option control groups, radio buttons and check boxes mainly. I'm trying to make a month selector for a query i use for export to excel, but on my own i just wasn't able to put it together. Is there a guide somewhere, or do you have any tips on how to...

Right, so that worked flawlessly right off the bat. I still got plenty to learn. Thank you, i appreciate this!

Hi Minty, sorry to bother once more, but.. Can i just put in an IF statement for this as a way to handle the "null" selection in the client field, for when im selecting all clients? Dim strPath As String Dim strFile As String Dim strCustomer As String strCustomer = Me.xKlientSelection strPath...

L O V E L Y, as per usual, I thank you very much!

Is there a way to make the name change based on the selections for instance? Like if i were to make a selection based on all my criteria, it could then reflect that in the name? Let's say i select active records, for the client "Pepsi co." for the month of July and it would say...

i just commented both warning lines, exported twice and on second attempt i got the same error and my query has been wiped.

Ok so, this form i made (the one i'm currently discussing here) "frmExportExcel" is a pop-up form on our "chalkboard" form (we use a physical board in our office where we write items we invoice to our clients at the end of the month), so this exists to give us options on what to export other...

How can i pre-define the output file name without giving it an exact location where to export to?

that's a czech word for forms, that part has been automatically generated by the query builder

I did not, I'm trying to make this work normally as it should, because i don't want to have to manually rewrite the query whenever somebody accidentally doesnt rename the file on creation. I'm not sure what you mean by the second question, but when the query has the code i posted on start and...

There's nothing relevant to this except for what i already shared, this is everything on the form Private Sub btnExcelBIG_Click() DoCmd.SetWarnings False DoCmd.OutputTo acOutputQuery, "dotaz1", acFormatXLSX, , True DoCmd.SetWarnings True Globals.Logging "Excel Export - Big" End Sub

Hello, I came across a strange issue while working on my Excel Exports. I've got a query I'm working on at the moment: SELECT Tabule1.TabKlient, Tabule1.TabOsoba, Tabule1.TabItem, Tabule1.TabQty, Tabule1.TabNote, Tabule1.TabAddedBy, Tabule1.TabDate, Tabule1.TabStatus, Tabule1.ID FROM Tabule1...

Hi, I had problems with this at first, but it turned out to be because i had the field default at "" instead of Null, thank you!

And the query keeps deleting its contents for some reason.... any idea why that could be?

apparently i've had it set up to 2 collumns instead of 1 for some reason, which caused it not to display what i wanted, don't understand how that happened, but ok. this works now, which is great! buuut, i have more questions: for instance, how do i set it up so that i can also disregard the...