Search results

Hi guys! Hope you can help me with this one. I have a form listing a number of players from a query. When clicking the okay button I wish to create a line in the table "stats" for each player listed in the form. In the player table, the playerID and the gameID (taken from a text-box in the form...

Hi there! I've searched this forum for like 30 minutes now, but I can't find exactly what I'm looking for. So I really hoped you guys could give me an answer instead. I'm quite new to this Access-programming stuff, so I would really prefer if you would relate to this question instead of posting...

Hi guys! When closing a form, I want my system to prompt: "Close without saving?". If yes, I want to continue the closing-proces, but when "no" is pressed, I want to just close the MsgBox-window and of course keep all the data-entries... If MsgBox("Close without saving?", vbYesNo, "Close?") =...

Hi! I'm currently facing a wierd problem, and I really hope you can help me! I have a query called "fsRapportSalgsoverblik2" which contains a list of all sales made from a company. I want to export that list to excel, which is no problem at all... But when I try to set a date interval, so that...

Hi guys! I've succesfully exported a lot of data to excel, but when I export date-columns the format in Excel remain standard-numbers... Is there any way I can change the column-format to date with an SQL-line. I've got a line in my code that adjusts the column-width and works:-)...

Hi There! In my query i can easily write "ORDER BY coaching.date" in my SQL. But instead I want to order by the output of a dropdown menu... I want the user to select what he wants the data ordered by! I have tried ORDER BY [forms]![coachingstatus]![dropdown], but that doesn't work! Help...

Hi folks! When you fx make a button to open another form, you can choose to open it only containing data where a variable is equal to fx a textbox in the form where the open-form-button is placed. That's what I want my report to do too. But i don't get that option, when I create an...

Hi! I'm currently facing a strange problem! When I want to insert a command-button, a drop-down menu etc. no userguides appear anymore. I like to do the most basic work in design-mode, so I kind of miss then a lot... How can I make them come back??? JR

Hi! I'm currently facing a strange problem! When I want to insert a command-button, a drop-down menu etc. no userguides appear anymore. I like to do the most basic work in design-mode, so I kind of miss then a lot... How can I make them come back??? JR

Hey Guys! I have a problem concerning the ability to make a reference to another column in the same query. I have two columns. Column 1 works perfectly, but in column 2 I want the outcome of column1 (coachingdato1) inserted instead of #17-07-2006#. How is that done??? Thanks in advance...

Hi folks! I have a listbox in one of my forms with the following RowSource: SELECT fsVisbetalingsprocent.navn1, fsVisbetalingsprocent.betalingsprocent1, fsVisbetalingsprocent.fradato1 FROM fsVisbetalingsprocent WHERE fsVisbetalingsprocent.sælgernr1=forms.vissælger.sælgernr ORDER BY...

Hi there! This should be an easy question. The billingperiods are stored in the table 'billingperiod' containing three columns: 'month', 'fromdate' and 'todate'. After update of a textbox called "navn", I want the 'fromdate' of the month 'july' displayed in Tekst18. This is my code: Private...

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

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

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

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