Search results

Hi everyone, Yet another question i seem to be stuck on for 2 days now. I successfully setup my SQL server 2017. My backend is imported and my Access front end reads all data and my databases work....kinda.... Problem: I have a form that has an on open event GoTo new record in my vba. This...

Hi everyone! I hoped someone could advice me with something on the old trusty forum :) I successfully linked my Access front-end with an Sql server and everything checks out. After some playing around i was wondering if it's possible to use VBA on my FE form that creates a new table on my SQL...

Hi guys! Im sure the answer is somewhere, but after a day of googling, I still need to ask. Please help :) What I want to do: I have a form, with filters on the headers, and I want to send the filtered results (records) to a table. Not overwrite, but add them. So what I did is copying the...

Hi everyone! I have a small question that im unable to find the exact solution for. It's driving me craaaaazy :D I have a query where I want to apply this: actualtime: IIf([daytext]="vrijdag" Or "Friday",([timediff]-48)) Now obviously its not working...but why? If my daytext is equal to...

Hi everyone! I know youre thinking there is alot of solutions out there to this, and a common question, however its driving me up the wall for hours on end and will not work. I have simply no idea what to try anymore :confused::confused: I have a linked excel file as my data source. I have...

Hi guys! Small question here I cant seem to find any answer for. Maybe im searching with the wrong terminology? I would like to use a variable to adres a table in my SQL bit inside my VBA code. What I try to do is this: Dim db As Database Dim rec As Recordset Dim...

Hey guys! Again, stuff just weirds out on me and i'm at a loss for something very simple...:banghead::D So I have a query with this statement: problem: IIf([difference]>=0;"Short";IIf([difference]<=0;"Over";IIf([difference]=0;"Ok"))) So my results are as follows: The "Short" seems to be...

Hey everyone! I have kind of a silly question: Im counting some values in a date range. I would like to sum the values afterwards. But I cant seem to do this in 1 single query. It becomes too "complicated". So what I always do, I make a new query of the current query and sum it there. My...

Hi everyone! I'd like to ask for some help I can't seem to overcome. It's actually fairly simple but I have NO clue what i'm doing anymore. I have an ODBC connect with a pass through query. The query works FINE! Until i try to filter between the date between 2 form fields. What is going wrong...

Hey guys! Whatsup? Ive been trying to find out whats going on all day, and its still a mistery to me. - I have a split database - A form with and On Timer event, running update and delete queries and so on. Everytime the Timer event cycle ends, my backend is growing. The amount of records...

Hi guys! I was wondering if it's possible to fetch the outlook profile picture and use it in an Access form. I was looking at IPictureDisp. But i have no idea how to use it. Can't find any examples for this either. Maybe you guys know if this is possible? Thanks!;)

Hi everyone! I know you're "not supposed to do this" within Access according to some other forums. But i need to do this because the information needs to be fed this way to another application. My question: How can i take an entire column from my query, and show the data in my form field...

Hi everyone, I understand these questions are always cheeky and people start talking about hacking dangers and what not. This is not the case and only want to automate a process at work due to restrictions of the user. Besides, i always just try to help if i can, if someone wants to do...

Hey guys! I tried looking for an answer but to no avail. I hit a wall every time. Maybe someone can help? I'm trying to "click" on an element with VBscript on a website. This works. However, first i want to check if the element exists with a loop. This would work, if not for the "Invalid use...

Hey guys! Could someone help me maybe? I have no idea what im not getting. I used this type of expression/statement before, but now i dont understand. I made a new field with the following code in the field name: buildsize: iff([volume_m3]<0,"smaller") But i get an undefined function iff in...

Hi everyone. I have a somewhat "general" question. I have multiple examples where i would apply this, but i would like to keep the answers general so others can learn this basic, but useful way of going about data. When i have a form, with a certain record source, that certain source is the...

Hey folks! Im stuck with this query. I don't fully understand where im making the mistake here. Some times, the query returns null (blank). In that case i want the value to be 0. The part i also dont understand: It's append query. When i put the default value as 0 in the table it appends to...

Hey guys, Im working in logistics (warehouse/stock systems). We use alot of Access and for sure you guys have seen me on the forum is thing :P Anyway, i would like to learn some new things. I know a bit PHP and HTML (and css). But i want to expand and build some nice warehouse system. Whats...

Hi guys! This is a new one for me. Could anyone explain why this is happening? I have a table with a autonumber field for ID. I use this ID as a counter on another form. This works fine! But when i want to use this value in a query expression (fetching it from the form field), i get letters...

Hi everyone. My "simple" code i cant get to work. I want the application to close at a certain time. So i have a table with a time in it to close. (i use a table because it needs to be able to be changed by the end user in some setup form). So i want to the value from that table and use it as...