Search results

Damn...i feel ashamed. Kinda need to get used to the fact that its double anyway. Coming from PHP background :D Thanks! would not have found out because its so silly

Thanks ISLA :) That did it. I should have know also... Just one more, where i calculate, but i get the same error. Again i dont see this one either :S checkorder: iff([cocota]<[rusty],"Total too high","Total too low")

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

Thanks for the reply guys! Well, it's multiple fields i would like. A set of data, that has the same value in the ID field on my main form (relation). I don't know the shortest way, to get a few records of data from another recordsource (or, the recordsource of my subform in this case into my...

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

Ai...not there yet. Now it says: Your query does not include the specified expression Sum(Scanned.quantity)=Nz([Scanned].[quantity],0) as part of an aggregate function :confused:

Aaaah yes. Indeed, i have 2 fields with quantity from different tables. I thought access would figure this out because im telling it from which table. But this is better :) Thanks. Next time i will name my fields different in the different tables Cheers!

Thanks for reply Ranman! Well, when i put NZ([scanquantity],0) it asks me for parameter when i run it. When i put NZ([quantity],0) i get an error: the specified field [quantity] could not refer to more than one table listed what is happening?

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

Ah i see. Sorry! The dumb thing about this is that i continued building, and the query is now an append query. (in my head i would fix this problem later) But now, it works... It appends and the number shows up in the table... Very strange. To clarify, the field i got the value from, was a...

Thanks man. Sure! session: [Forms]![session_counter]![ID] this is in my query. (to narrow down the database and zip it is really too much work in this case :D)

Hi Ilsa. Thanks! No i am not. I add a new record in vba to the table, this result is visable on the form, then for ease of use, i just take the value on the form into my query. I know sounds a bit around the clock, but it's fine i guess.

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

If we in ANY possition to fix the network, it would be solved today :) The thing is that our global IT department does not "support" Access. Although our argument is that they dont need to support Access, but the network causing the problems! But alas...no avail. I think it's a cool challenge...

Howdy ladies and germs! Well, this is probably a topic many of us struggle with and have it solved i guess. GENERAL PROBLEM: We have a big company network with multiple windows and access versions. We're running a split database (front/back-end). When a network interruption occurs, the...

Thanks for that swift reply! LVALUE = SendKeys CStr(Me!Width) Expected end of statement... :banghead::D LValue = CStr(Me!width) Like this is ok ofcourse. But i need to send multiple keystrokes :S

Thanks JHB! Sounds like a good solution :) Dim LValue As String LValue = CStr(8) So how would i go about this? LVALUE = SendKeys Me!width Like that?

Thanks minty :) Ill try fix that and will come back to it. I have a strange problem going on aside right now. Im testing it. It all seems to work fine. Just when a value on the form for example is 0,99 It outputs it to notepad as 99 In my query there is 0,99 On my form its 0,99 But on output...