Recent content by klwu

Never mind, I have solved the problem...I forgot to set the cmbStockCode to enable....:o

Hi, I am stuck at a point where I want to set the focus to another control when a control has been clicked. e.g. I have a command button (cmdAccept), when this button has been clicked, I want to disable this control, and move the focus to a combo box (cmbStockCode). How should I achieve this? I...

Hi, I have a couple of macros set up for customing a menu bar in my application...and link the macro to my splash page....however, everytime I run my splash page, the menu keep adding into the menubar, makes the menu bar longer and longer.....I don't know what's wrong with that...anyone know how...

Hey, I have a query to calculate the stock balances and their values.....the client is using FIFO method...therefore, the stock may have different values at different stage......but they want to display the latest unit price in the report.......I selected "Last" at the UPrice column in the...

any help would be highly appreciated. Thank you.

Hey, I am using VBA codes to insert data into the tables, however I found out one problem......when I try to insert ('), the code returns error.......but for quotation (") is fine.......my code is as follows: sql = "INSERT INTO M_Stock (StockRef, StockDesc) VALUES ('" & txtStockRef & "', '" &...

I need to create a query to calculate the value for a stock in FIFO inventory method......when the user creates an issue......the system will query and calculate the value of the stock based on FIFO....at the moment, the query did calculate the qty excellently, but just the value of the stock is...

how you link the criteria to the report?? using DoCmd?? I don't know about others, but what I will do is, I will set the parameters of the report to read from the combo boxes......and then use DoCmd to open the report with the parameter......like this: Dim stLinkCriteria As String Dim...

I don't really understands your question, if you put the data that you want to appear at the end of the report, you surely have to put it in the report footer.....if you put it in the page footer, it will appears at the end of every page..... what do you mean by "can not use a report footer" ?????

I have a field [Date] in one of my tables, and the field is set to Date/Time datatype....format is "mm/dd/yyyy"......but when I type in "03/29/2005", I get an error saying that "the value you entered is not valid for the field"..... It was working fine yesterday....but it's not working for...

thanks max and roy........ after adding both setfocus and acdialog command, form B now loads in front of form A........thanks a bunch

I have added the code to form_load on form B.......however it still loads behind form A....thanks anyway

I have 2 pop-up forms.....eg Form A and Form B.... This is what I want to do: When form A loads, it will first look for appropriate needed data from a table.... if .eof then form B loads on top of form A for user input.... Q: How can I set focus to form B when it loads? I tried the...

Hey, is there a way to get the full list of tables in the database by using VBA? I am trying to do a backup function, where I want the database to fetch all the table names and put them into an array, to export them one by one to the backup file........hope you guys understands me.....thanks in...

oops...wrong board..... :o