Search results

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

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

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

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

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

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

Hey, I have searched through the forum for my problem, and I have got one solution that might work... which is turn off the auto correct feature......but I don't know where to find this auto correct feature....can someone help?? thanks

I wanted to create a Stock Movement Report, but I am not quite sure how.....I need some help..... I have these tables: M_Stock (Stock information) T_GRN & T_GRN_Detail (Good Received information) T_IIS & T_IIS_Detail (Internal Issue information) I need to do a report stating the opening...

Is there any way to convert an Access front-end to .EXE file? Please help!

I have a Maintenance form in my database, where the user can change the ref. no of a particular supplier. This form contains one comboBox (list all the current RefNo of suppliers), and one text field for user to key in preferred RefNo. I have wrote the following code for the 'Assign' button...

Listbox requery Hi, I need some help on this. I have a form that used to display suppliers information, and I have a listbox to display the products supplied by a specific supplier.....what I want to do is that, I want the listbox to requery whenever the user select different supplier....Could...

Hi all, I have another problem :( :eek: When a form is open, I want to change a specific field data to something else (e.g. from 'New' to 'Read'). I wrote the code using UPDATE statement however, when I debug, it keeps giving me error. Could someone guide me please? Thanks Private Sub...

Hi all, I have some listboxes on my form, I want to do like when the user double-click on one of the options in the list, a form will automatically pop up......is there a way to do this?

Hi, I have another question. I want to make one of my page refreshes every 5 minutes, I have already wrote the code for the Timer(), but how do I set the Time Interval? I don't know how to calculate that one. Thanks!

Hi all, I have a T_Log table in my database, which basically records all the log histories of users. I want to create a command button where the user can delete all the log records. How should I write the code? Thanks.

Hi, all I am trying to make a progress bar from this thread , however I keeps getting this message: Run-time error '2763': ProgCtrl returned the error: Invalid property value. When I go to debug, I found that this line of code ctlProgBar.Value = intCount is getting the error. Could anyone...