Search results

Galaxiom, Thanks for your GREAT answer. As you suggested that NameAutoCorrect might cause corruption, I'll give a try to V-tools. Thanks to both of you as I was about to change a table field name and I now realize that it's also not always necessary as the end user doesn't have to see them...

I'm building an Access database that is growing bigger, and I might not have considered this aspects when I initially started. So what is a good method to find out whether you have too many relationship between your tables? :confused: Thanks in advance!:D

Hi Paul, sorry for the late answer. I have been implementing the solution you proposed. It's indeed far better organized with an additional table containing the times and normal/overtime hours coefficients. I am now implementing the Dlookup (which I had never used), so I will keep you...

Hi people! :confused: If I manually change the name of a table fields, will all the other references to this fields (in queries, forms, controls, procedures) be updated accordingly to reflect the name change? T.

Hi Paul, Thanks for the hint! :) I made a table as you described, defining the Normal/OverTime hours in a new table, with every record corresponding with a particular contract. I haven't used DLookup yet so I'll post again if I have additional difficulties. Take care, T.

Hi everybody, :D I have a database where I put timesheets information. What I have done is a form where the user only has to input the [Start Time] and the [End Time] of a worker. From there, I want the form to compute 5 figures: (1) Normal hours = all daytime hours, for example from 8AM to...

Lagbolt, This is exactly that. This was such a silly mistake, thanks a lot for pointing that out ! I just ticked the Variable Declaration check box, thanks for letting me know on how to correct this :-) Have a great day, T.

I think John's reply is in the right direction. I've recently also have a similar issue as you and I solved it by: (1) Creating a Public string variable for the filter (call it strFilter) Public strFilter as String (2) Creating a module that will update strFilter depending on the value for...

Hi All, This is my first post on this forum :-) I've been coding this Sub in VBA in order to do web scrapping. I managed to extract the HTML code from it, that is stored in the string variable readHTML. readHTML (the string var) looks like: [...] <DIV id=name class=editable-item>...