Search results

Hi guys, I'm trying to add a specific name to the column headers on a value listbox created manually on VBA, and can't find out how to add the tittles I want on each column. Everything works perceftly, I just want to add the column head names on the listbox. This how the code is structured...

That is exacly what I was looking for, thanks a lot for your example! That is right, but the thing is all the users are accessing the db from the same computer (server), while I manage it using a local copy in a different one. So I assume that would not be a problem since I just need to...

Hi guys, when I have to update the my Database_fe I have to manually go computer by computer and shut down all databases that are open. I wonder I there is any way to close all of them, but not mine, for example just by clicking a button in my admin panel. I've found a particular example in...

Hi guys, thanks for all your help, I ended up solving this using this expression: DCount("*", "tblWhatever", "[Date] = #" & Format(Date, "mm/dd/yyyy") & "#") Not sure why, it only worked for me using english dates. Indeed I'm not from UK but I work with a english version of Access, so maybe...

Hi guys, I'm having a problem when trying to DCOUNT the number of total records in a table, containing a specific date in a Date/Time field in this table. The code I'm trying to use and that used to work for me is this: Dim dDate as String dDate = "#" & Date & "#"...

Hi guys, I'm stucked in a point while elaborating my project, where some of the data I need is variable and changes every day (copper price). I was wondering if there is a way to get this data from an external website so I don't have to introduce it manually every day by myself. I've seen in...

Thanks for your answers, indeed that was exacly what I was looking for, didn't know it existed such a function to call this specific symbols.

Hi guys, I'm having a problem when inserting a specific special character in a VBA code. I need this character (Ω) to show up together with a string after certain action happens, but Access does not let me paste it in the string field, it shows "Ù" instead. I've tried to create a query with...

Indeed, that was it, as soon as I closed up the timer it started working again. Thanks a lot, this has been driving me crazy for 2 weeks :)

Hi guys, thanks for paying attention on to my problem. :banghead: I'm having a very strange problem on the VBA editor, when writting or editing code on any form, report or module. Basically when writting, the editor autocompletes the code even before I finish the line, which makes me not being...

Indeed, sorry for not paying attention. I could sort it out thanks to you guys. Appreciate your time, have a nice day :)

Thanks a lot guys for your quick answers, I did manage to solve this particular expression, however some of the strings I need to use contain text as well and in that case it is not working, not sure why, because I'm treating "strE01" exact the same as "str101". Private Sub Form_Current() Dim...

Hi, guys, and thanks for reading my post. First of all I want to say thet I've only been using VBA and Access for 1 month so my knowledge about programming is low. I've been checking several tutorials and threads on the net to get this solved, but still I could not find a solution and my...