Search results

before even trying to do that if I have only two users who use this access database if this database gets around 1500 new lines a month if those two users work on the same table (tables) what is the chance that I get in trouble when let's say they modify the same recordset in the same time...

I did that I installed them too started mysql as service The thing is when u want to upsize the tables access knows only Ms sql server. So I have to connect to mysql by a string connection I suppose. It's only that I don't have any idea of how to even start this. Plus, my actual work is made...

Hi there Did someone connected a Access database to a windows Mysql db through ODBC? I am talking about the windows version of mysql and windows version of ODBC drivers for windows Thank you

thanks raskew It works like this ..maybe Im wrong, but it appears to work with xx:xx format If its x:xx -(like 9:00) or xxx:xx (like 123:30) it ain't Which is normal, but I cant get the right solution to modify so that accepts 1 or 3 or 4 caracthers before : ( that I need ) Sorry for...

I know its kinda late, but... Actualy your function is not made for hour format, but for days. I can't pass it a value like 45:33 (which I want) So again, and I have searched this forum for over two hours without succes, I need a function that does the opposite of TimeFormat showed upper...

Thank you Mailman My life it would have been better if we had an hour format over 24h limit for calculations. In vb is the same?

There is this function : Function TimeConversion(ByVal tempTime As Date) As String 'On Error GoTo Err_Error ' This routine is given values from the calling procedure and calculates the time ' beyond the obstacle of a 24-hour clock Dim lngDays As Long, lngHours As...

It was working since the beginning, but after my calculations it was weird it was working :-) But now I kind of understood the loop in the form records.

yes, that helped Thank you

hey mailman if you could explain me a little thing in your code it will be great. In the line: If rstH.Fields(3 + Weekday(myDate, vbMonday)) Then you are looking to see if Monday is selected, and if so you send over the loop to the next instructions. Correct me ls if I'm wrong. After...

Hi again Do you have any idea where can I find online the complete syntax for the 'Loop' in Visual Basic ? I've searched the site of Microsoft but I got lost. Thank you

Namliam, it works like a cold beer after a night of drinking...I just had to change rstP!nopl with rstP!codeclt cause nopl was the Primary Key and I needed only the client code to walk there. Thank you Sir

Thank you a lot Mailman I didn't hope for such a reply. I'll try it now PS I'll stick to name convention and to english next time :-)

Hello I attach here my little base to be clear. On the form named Clientcontrat I have the code of the client, the starting and ending date of the contract, and the days + number of agents that has to be covered. I want to pick up those and (by pressing the button 'planning)populate...

Actualy I wanted to use it, after I've changed my mind, and after forgot to erase it...Mea culpa.. Thanks for help and yes, I will name the buttons after their function.

just like 10 seconds before u're reply, I did this: Private Sub Commande72_Click() Dim strSQL As String Dim a As String a = Me!Texte45 strSQL = "INSERT INTO probleme(descriptionprb) SELECT Forms!ffiche.Texte45;" DoCmd.RunSQL strSQL Exit Sub ...and it worked just fine. Tell...

hi Bert are u sure that the quotas are good in u're code? I get a msgbox as Me!Text1 was not functioning

Thank you guys

Hi I have a form called x On this form a text field named Text1 I want to pressa button so that what was written in the Text1 field to go in a table I did something like this: Private Sub Commande72_Click() Dim db As DAO.Database Dim rc As DAO.Recordset Dim q As QueryDef Dim a As String Set...

I avoided the problem usinf a query as the source of the sub form. It is healthier and it works