Search results

Hmmm.... Thanks so much for your quick reply. I want to use it in this situation: I have two textboxes. When I open the form the second box is empty, but when i fill out the first textbox I want a standard-value to appear in box number two. How is that done then???

A simple question that would probably take me hours to figure out by myself: When I want to change the source of a listbox, fx. when a button is clicked, i use the command 'rowsource ='. But what command do i use to change the source of a textbox...?? Thank you in advance :-) // JR

That was stupid Please dont answer this one... Plenty of bad stuff in there... I figured it out! - Update (not insert) - RunSQL (allways a good idea) - And on and on and on... Sorry

Hi there! I'm quite new to this SQL-stuff, and I'm having some troubles with an onclick-command, that I was hoping you could help me with... I know that it is a very simple question to you SQL-guru's, but what the hell...:-) In my form I have three text-boxes (I1, II1 and III1) and in my table...

That worked... Thanks!!! Thanks for your help! Its running smoothly now!

Please reply Hey guys! I would really appreciate your help on this one... // JR

Thanks for helping Thank you so much. I will try to implement it in my system on monday... And then we'll see if it works! Have a nice weekend! // JR

Hi Guys! I want to insert an update-button in my form (see attachment). When i use the Access-guide it inserts the following line into the buttons onClick-code: DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 But then I get this strange error: "The update-command is currently not...

Thanks for the tip Thanks for the tip... I'll try that right away!! //JR

Screenshot! Shit, I forgot to attach the screenshot, but here it is... :-) Mike, nice to see you here again :-) I think you got it a bit wrong, but that's my fault. Hope you'll check out the screenshot and post a new reply! Even if only a few of the boxes are filled (with coworker-numbers), I...

Hello everyone! Before i forget: Sorry about my three identical posts before :-( Here is the thing: I've attached a picture of one of my forms (on a very early stage). I want to save the inputs into a table1 containing all the coworkers. I want to write the value 'X' into the column selected...

Hi There! I have two tables 'table1' and 'table2'. They both have 'clientnumber' as the keystring. I want three textboxes in one form: 1) Textbox1 bound to 'clientnumber' (key) in table1 2) Textbox2 bound to 'clientname' in table1 3) Textbox3 bound to 'xxxxx' in table2 where 'clientnumber' is...

Hi There! I have two tables 'table1' and 'table2'. They both have 'clientnumber' as the keystring. I want three textboxes in one form: 1) Textbox1 bound to 'clientnumber' (key) in table1 2) Textbox2 bound to 'clientname' in table1 3) Textbox3 bound to 'xxxxx' in table2 where 'clientnumber' is...

Hi There! I have two tables 'table1' and 'table2'. They both have 'clientnumber' as the keystring. I want three textboxes in one form: 1) Textbox1 bound to 'clientnumber' (key) in table1 2) Textbox2 bound to 'clientname' in table1 3) Textbox3 bound to 'xxxxx' in table2 where 'clientnumber' is...

Hi Guys! I get a strange error, when inserting the update-function into my code: DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 I have the same line like a million times on other parts of my code, but one time I get the error: "The update-command is currently not available"...

Thanks again! It works! Thanks again!

Hi again! This time I'm having some problems finding a way to determine the output of a scroll-down menu (or in my danish version of Access called "combination-box"). In the menu I can choose between a number of names from a table. But when I select the name and press the "OK" button that...

The man once again Hi both! Thanks for the replies. I fixed the problem using Mike's suggestion. I sounded a little simpler... You're the man once again, Mike. Thanx! // JR

Thanx You are the man!!!! Thank you!

Please help :) Hey again! It is really important that I understand this principle, since it is a cruscial element in my db-programming. It might seem simple, but the more I need to understand it...:-) Thanks in advance!