Search results

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

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

hey,...that's a great idea........hmm.....never thought of that...let me work out a sample report for them to see.....and compare the "unreadable" report to them;).....hope they will be convinced.......thanks a bunch............:)

I guess no...... just took a double look on the report....it's not suitable to split it into 2 lines.... the sequence is like this: StockGroup - StockCode - Desc - DocNo - DocDate - Qty - UPrice - Total maybe you would have better idea how to split these stuff in 2 lines.....if the client is...

thanks for taking the time to reply......but the client DO NOT want to change.....they were previously using portrait size....and they WANT BACK portrait size.....:( moreover, they are using computer form (continuous papers).....if the report prints in landscape, I guess that would be a big...

I have a few reports but I am struggling on choosing the right font for them....I need a narrow font (because my reports are wide, so I have to make the font small) as I'm using dot matrix printer to print......and the reports came out unreadable.....I tried to change the font from the...