Search results

oh nevermind, upon switching it back to not display the first column, it once more is bugged...

so uh, yesterday when i left work i saved my project with two semicolons (which at the time didnt display anything even upon restarting access) and today it displays what i wanted correctly.... access is a mystery.... thank you guys regardless.

yes, the first field are numbers representing the months. upon changing the size of the first column to 2cm from 0cm, nothing has changed.

Hello, I got two combo boxes next to each other, one of which is a month selector and the other a year selector. For some reason i'm unable to display the placeholder text on my month selector. I have tried various combinations such as @;"Mesic";"Mesic" to make up for the fact that it has two...

I did search and i tried a couple things, but nowhere i found a solution with the format in front like this i tried 'Me.lblTotal.Caption = Nz(DSum("CashTotal", "dbCash", "Format[Currency]"), 0) and was toying around with it, however, your solution did indeed work and im greatful for that, thank...

Thank you Arnel, i'm trying to also format it to Currency, is there a way to do that?

Hi, I can't find a way to run a sql code, namely this: SELECT sum(dbCash.CashTotal) FROM dbCash; and make it's output a label's .caption. Anybody knows how to do that?

Oh yes! I'm new to this still, but as far as i understand, this would be one of those times for a "well, because it's Access" remarks.

Thank you @arnelgp but that's not really what i was trying to do, i was attempting to create the tempvars based on a table instead of just a txtbox. Which i ultimately achieved using a recordset like this Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("tablename", dbOpenSnapshot...

I got too many errors regarding handling objects instead of values so i just try to make sure by using .value for example right now as i was trying to establish this full name tempvars i attempted using recordset to provide the value and i do not understand how recordsets really work, so my...

Hello, I have made a second post regarding this and more here. I just want to ask seperately in a diferent Forum section as i'm not sure i chose the right one before. I would like to save a TempVars value based on a column in my account table, but i don't know how to pull that data from there...

Hello, I Pretty much need to do exactly what's in the title. I've got a "BElogon" table where i save all my User Information, there's one row for a full name which i would like to save now into a record from an unbound form where i use a simple query like this to populate the records columns...

Hi, I'm looking for a way to handle somewhat lengthy descriptions within a listbox without making the row longer but taller instead, is there a way to adjust a listbox's rows to scale automatically to the text? I'm trying to avoid listview as i have no experience with ActiveX and seeing as i...

Thank you, as per usual, this has worked! But what's the diference between these two?

The query works just nice, it's the "IF" statement that doesn't work for me.

Hi, I have a form that tracks our currently pending invoices. In order to "finalise" an invoice (set its Status from 0 to -1) i've got a pop-up form that has 3 buttons on it. Each button applies the -1 value into diferent records, one button takes a single selection from the underlying listbox...

Thank you very much for your feedback!

(just for fun) I have thought of maybe the most inconvenient way to handle this! It would be a button + textbox combination, let's say we name the textbox "txtBox" and the button "btn1" You could then go to the button's Click event and set it to this: Private Sub btn1_Click() txtBox.Value =...

Well if he indeed wants a selector for the numbers 1-100, the most convenient method imho would be to have a textbox instead of a combo. Then set the Validation Rule to : <=100 and then set the Validation Text to something in the lines of: XXX can not be a number higher than 100.

Hi, could you try to describe your request a little bit more detailed? Are you trying to make a combo box that shows all numbers 1-100? I'm confused.