Search results

Hi Joe, Glad you're finally here!

Hello SARH, Welcome to AWF, Great introduction!

Hoi Elio63, Ik zou een tabel maken met prijzen per verpakking dan kan je die in een query berekenen en dat werkt sneller dan het gebruik van iif statements. Het geeft niet dat je beginner bent in Access. Dat zijn we allemaal geweest. Vraag gerust en er is altijd wel iemand die er iets vanaf...

Yes, i have a few thoughts. - the linked table is in fact an excel spreadsheet and therefor is read-only - you are inserting the same record twice. - use don't use # to specify dates - the dates are in a wrong format mm/dd/yyyy or yyyy/dd/mm or any other wrong notation - you don't have write...

You shouldn't update your table with process data. Similar to Excel you would use a VLOOKUP. A VLOOKUP is dynamic it stores a formula and not the actual data. Use a query to display your proces data. That way the result is dynamic like a VLOOKUP in Excel. Your table doesn't appear to be...

A few things come to mind: Your database design needs a little work. It is not normalised. The fields: TQ1, TQ2, TQ3, TQ4, TQ5, TQ6 ,... is a repeating group. You have 5 append queries which are used to fill 5 tables. Why not use these queries as tables? And i am not sure what you are asking...

Another solution to your 1 record problem is to use an unbound zoom form. Show the value the user can edit and build an update sql statement to save the changed value. It just shows the one value and nothing more. Tab brings you to the other control and you won't cycle through your recordset...

Hi zeroaccess, The thread you are refering to is marked Solved. You should respond to that thread if you have questions about it. I just added my 2 cents. HTH:D

Instead of passing arguments in the openform statement, like MajP suggested, you could use TempVars to do the same. Private Sub Form_Load() 'On Error Resume Next Dim frmName As String If Not IsNull(Me.OpenArgs) Then frmName = TempVars!WhatEverYouWant Set Me.Recordset =...

Firstly, you don't have to open a form in design mode to loop through the controls. Secondly, the rest of your question i don't understand. Can you elaborate?

Thanks for all your input! TempVars in summary: Declaration: Dim tv as TempVars TempVars!tv = 22 Is the same as TempVars.add "tv",22 You can also change the variable type by simply storing the other type. TempVars!tv = "Might come in handy" TempVars!tv = null...

Add line "291 Resume" When the error occures drag the yellow right pointing arrow to this line and press F8. That is the line where the error happens. My guess is that !QR produces the error. I would use .Fields("QR") but that is because i dont use ! Or you can try to set the breakpoint at...

I got an application in which they used TempVars a lot. Since i have never had the lack of pleasure of not having to use them i will have to now! So i was wondering why did M$ added the TempVars collection? Is it a special collection with added features and if so what are those features? Or is...

Did you try rebooting? If the problem persists, you need to give a more detailed error message. Did you compile the code? Is it 32/64 bit related? Open your code window (ALT-F11) goto Extra | References, is a reference missing? HTH:D

LOL Yes i did!

Thanks everyone, especially Pat! I have always preferred the dot above the bang because a dot always showed intellisense. I wasn't aware that nowadays the bang also shows intellisense. Secondly i was searching for a reason to always use Me in front of controlnames. Your explanation is very...

I always use a dot and never an exclamation mark. Is there a difference? Is one faster? And line 1000 compared to 2000? Example: 1000 frmProgress!cboProcesstatusG = rs!StatusProces 1001 frmProgress!txtDatVooraanVerzondenG = Format(gsJAL_G!DatVooraanVerzonden, "dd-mm-yyyy") versus...

I just read it. Thanks!

Small question: Is it possible and if so, how, to convert an Access application to an android/apple app? Thanks!

Perhaps this thread should be a sticky? Link to Access Junkie Jeff Conway doesn't work