Search results

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

You're an absolute legend! Very clear. Thanks!! :)

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

Hey guys! Thanks for all the answers. Indeed the table looks a bit off because I didn't want to put the full name because of some security issues. Anyway the table is fine. Everything works fine, until the BETWEEN form dates need to be put in. So it's not possible to take values from these...

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

Thanks man! Side-end sounds like an option. Anyway interesting for other applications also. Will try! Thanks for answering gemma, but it's growing 50mb every 2 minutes.... And there are NO records ADDED...

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!;)

Thanks you so much guys. As always, great community here and not comparable to other forums on any coding language. =ConcatRelated("pallet_ID", "staging_t","ordernumber Is Null") Is what i used on my form field. Works like a charm. I was stressing too much :)

Hi CJ, But the solution essay put up there is a quote of the SQL code... I dont understand how to use my where clause or where to put it. Yes, i would like to use it in my form field...but i only get syntax errors. I'm still learning and studying everything. But now i needed to ask for help...

Hi essaytee! Thanks! No i havent. But i did read this part... You're right...he probably was talking about the function itself :). But i have no idea how to include it into the function. On top of that theyre pressuring me for time over here :eek: I would also assume, my query FIRSTLY...

But not quiet LOL So it DOES concat all the numbers from the column. But as you can see in my SQL, i have a WHERE clause where i'm saying that i want all the numbers in the column where ordernumber is NULL. Right now it gives me only the record where ordernumber is NULL, But in my expression...

Thanks for the swift reply CJ! Works like a charm :)

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

One tip with a split database to avoid most corruption... "Don't Delete Data". Use append data to another table or something. Most corruptions happen when a record is deleted from a table that people use at the same time. Concerning the front-end. I always set it up like this and never had a...

I would use conditional formatting for your fields that are required. Try this: - Right click on the field that's mandatory in Design View. - Then click "conditional formatting". - Add a new rule. - Use: Field Value Is Equal To Null - Set your background color to red. (So the field will be red...

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

theDBguy = theMASTERguy Thanks man! That worked! I was so caught up with vbs that i forgot regular simplicity. Youre the best:):):):):):)

Hi DBguy! I wouldnt think so. But if i dont, i get object required.... :banghead:

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