Search results

Hi, I have some code that set up a logo in Excel thu VBA code in Access all of a sudden, I am getting the 1004 error ...... at the .filename = .... Dim strLogo As String strLogo = DLookup("path_logo", "parametre_general") Debug.Print strLogo 'bypass insert logo if...

Found the solution, does not like the : in the file name Thanks

Hi to all, I am usinh the mane function to move a file from 1 folder to another one but now I am getting the error 5 invalid procedure call or argument , wsa working before but no anymore does anyone had this problem before ? this is how my code is strName =...

Many thanks, working

Sorry for the delay, was cought up in an emergency all day. the line of code that generate the error is If Dir(strName) Then the variable display the following: R:\ED\DEV\Entrepot*.accde I just canmnot figure this one out Thanks

Hi, i want to check if a file alerady exist but when I run my code I get the Type mismatch error I cannot figure this on out, my strname display the proper path and there is a file there, the wildcard is there because the number attached to the file name varies strName = "" &...

can you elaborate a little more on what you mean about version ? not sure of what you mean Thanks

Hi to all, I have a very strange situation here and I hope someone can really help shed some light on this. I have a db that is currently working just fine. the problem is when I create the .accde file, the end user is not able to open it. I am getting 2 different msg dependin on how the db is...

I have checked with the admins and they claims that nothing changed. I always backup my work once a week, friday PM, Yesterday, I needed to make some small changed , half dozen line of code to add validation, complile make .accde and problems. I decide to test something else, I copied my last...

RanMan256, these is no on else using the db, no lock file open at all, already check it out before posting

Hi, our backend is on a SQL server and yes, I have check the user permission and she has them, so that is not the problem for sure

Hi to all, I have been working on a db for a couple of weeks now, on my side, everything is working the way it should be. We have different proces to test and approve db changes (meaning different folders with different users for testing like QA, PPROD. I just deployed a version with minor...

Hi, I am not sur eif this is the right section or not, I have a small syntax problem and after trying all possible syntax I cannot solve this one I need to update a table with a replace function in it but I always get the synbtax error, this is the code I use right now: strFind =...

Many thanks for the help averyone, I just manage to make it work, the solution is for me to hardcode the listbox rowsource everytime I need to make change and requery it instead of passing the SQL string thru variables, now it is working fine Regards

Sorry about the confusion, when the form is open it pick up the rowsource from the listbox control Private Sub Form_Open(CANCEL As Integer) 'set default rowsource from choix_document strOri = Me.CHOIX_DOCUMENT.RowSource 'pick original val for later process intYr =...

this is the SQL of the rowsource of the list box SELECT LISTE_CONFORMITE_DETAIL.VALID_DE, LISTE_CONFORMITE_DETAIL.VALID_A, LISTE_CONFORMITE_DETAIL.ID, CONFORMITE.NOM AS CONFORMITÉ, LISTE_CONFORMITE_DETAIL.DESTINATAIRE, LISTE_CONFORMITE_DETAIL.RESPONSABLE, LISTE_CONFORMITE_DETAIL.DOCUMENT_CODE...

Does this where clause make any sense ? I think that might be the problem, rusty on Access queries WHERE 3/31/2015 BETWEEN CDate(LISTE_CONFORMITE_DETAIL.VALID_DE) And CDate(LISTE_CONFORMITE_DETAIL.VALID_A)

Hi, already done and my strOri is set at the form_open() Private Sub Form_Open(CANCEL As Integer) 'set default rowsource from choix_document strOri = Me.CHOIX_DOCUMENT.RowSource 'pick original val for later process intYr = Me.CHOIX_ANNEE.Value intPer =...

yes, both and no results

the if statement and the .oldValue works as expected, the real problem is when I need to refresh the listbox after the listbox rowsource is set back to it's original SQL string