Search results

Hi guys, I'm having a trouble with a form where I am using a KeyDown and KeyUp event to enter a pin and log in the database, and it works nicely when all the elements on it are labels, but it appears that when adding a button on it it stops working. I think this is because the button gets the...

Hello guys, I'm having a problem when using the like operator in a specific way I need. I wonder if someone could help me out with this. The problem is I require the SQL to search a specific part in a string and can't figure out how to do so. String example: str = "blablabla 16x1 blablabla"...

Hello guys, I'm having a problem since long time where I can not add totals in the page footer of a report, it returns me an error. Totals work fine in report footer and specific group footer but not in the page... The reason I need this is to have the sum of an amout placed in the very bottom...

Hello guys, I'm having troubles witht he recently implemented new version of MS (2201), I've read that many people is having issues with it, could someone please help me to downgrade the client to 2112? I've been trying to do it through the dev tool, saving a .xml with the target version and...

Hi guys, I'm having a problem with public variables. I assumed variables defined as public can be accessed from any form and looks like I can not. The variable is basically supposed to store IDUser, which is the user logged in and that is operating through the forms, and I need to store it...

Hi guys, I'm having a trouble when using DLOOKUP function and combine it together in the SELECT clause of an SQL expression, i wonder if this is actually possible to be done, and if so, I would appreciate help from you, because I can't come up with the correct syntax to make this work. I'm...

Hi guys, I'm having a problem when trying to compare two floating values, and I have no idea what happens here, I hope someone can help me out with this. What I need is to compare a value stored in a table (set up as a double on it) with a operation done, and return true or false if it is the...

Hi guys, I'm trying to create a simulator of a specific product I use in my project which depends, on the colour it has. So in a form, I want to change different parts of this product's color (I'm using rectangles) by just clicking on the control and display the Access color picker to choose it...

Hi guys, I'm trying to prepare an automatic email for sending when performing an action, and everything works fine but the default signature I have established in Outlook disappears when adding a body using VBA. I tried to capture the signature before editting the body and add it after, but it...

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...

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, 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...

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...

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...

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...