Search results

Hi all i have a simple access form with a kind of a chrono field (the 'timer function' is inserted in the code) when the user hits a button, it registers a timestamp and another field starts the count timestamp is saved in box 'begin' the other box ('chrono') contains the formula...

Hi Guys Thanks for the many suggestions I tested some things and apparently the check1 of Me.check1 returns a null value (somehow strange because i can see a value in the box when the form is open) I used a workaround now: instead of getting the value out of the box, i get it out of an...

Hi All Who can help me out with this situation... a form, with some items and data on this form, a list box named check1 that returns the value of a query (only one record/value) and a commandbutton ------------------------------------------ target: when i click the button, the value...

Works perfect! Thanks guys

Hi guys This should be a rather easy question, however my knowledge (and Google) dif not foresee a correct answer. There is a form (frm_input) with a button 'SaveDocument' this button executes an append query (works perfect) after this query is executed, I want to display a messagebox with...

Hi Back with this same issue, but found out some help already basically this is the situation now: -table with data (let's say invoices, invoice amount and client number) -query (simple select/totalize query) that calculates the total per clientnumber (client number is asked as parameter to...

this export routine was simply done by the macro I had a macro with Output to and details: Object type : Query Object Name: 700010_ Output format: Microsoft Excel 97-2003 (*.xls) Output file: Autostart: Yes template file: Encoding: I guess something similar needs to be done by code...

the button used to be a macro that executes a query (exporting the result into excel) this is the SQL code behind the query SELECT [tbl_BPM accounts].[BPM account], tbl_individu.[N° Magnitude] AS D_PA, tbl_kpi_data.Source, tbl_kpi_data.[Accounting Doc Nr SI], Sum(tbl_kpi_data.T7000) AS...

The name of the list box is now List0 i reversed your methodology and overwrote the name of the list box to LstCust code seems ok now, but nothing happens when i execute it where in the code do i need to input the 'command' to execute the query (over and over)?

Hi again This is great! question posted, and instant code for the answer unfortunately the debugger opens and show me the first error: it is situated here (bold): Dim vItem As Variant Dim Ctl As Control Dim CustID As Long Set Ctl = Me.LstCust '/Loop through the listbox for only...

Thanks for your reaction my knowledge VBA is poor,however with the help of this forum and some of my colleagues, i am sure it will work I think i can manage making the drop list (combo box) but how can I write the function to run the loop over and over? :s any idea how it needs to be built...

Hi guys first of all a lot of thanks for those of you posting helpfull info it already helped me out a lot! This time I have a specific question, but not much of an idea where to start or how to manage: I have these items (simplified) -table with data (let's say invoices, invoice amount and...