Search results

I have a combo box that is linked to product name and should allow the user to pick the product name. this combo box is reading from the product table, but when I add a new product name, the name does not appear in the form combo box unless I close the form and open it again. I understand that...

realtion between category table and products table should be one - many. when i make the relation, it is always one - one. this is of course making impossible to have 2 prdoucts with same category in the products table. attached is my current table relationships, please guid me for a fix if...

I have a form that set to open in add mode so previous records do not appear. I want to have a button that will make all reords appear for the user to edit them,. what code is required

I designed a welcome form that will have 3 labels set their visiblity to False and wrote a code (based on example in a web page, so it is not mine I have to say), to check for current time and display label (set one of the labels to visible = true). the code is as follows: Private Sub...

I have created a cross tab quarterly query to sjow the 4 quarters sales. Problem is if there is no sales in one of the quaerters, the report based on that query gives an error as per attached photo and do not open. any work around

I managed through a code on this forum to do compact and rapair on a button click as follows: CommandBars("Menu Bar"). _ Controls("Tools"). _ Controls("Database utilities"). _ Controls("Compact and repair database..."). _ accDoDefaultAction but then the dialogue winodw pops up to ask me to opn...

My reports are based on a query and a date inout form for the user to define date range of the report. How can I enable the report to open all records if there are no date range specified by the user.

I have a field (DueDate) that will blink (flash) if it passes its value problem is the text to the right of the navigation buttons is not showing the number of records unless I navigate till end of the records. I tried Me.Requery and Me. Refresh but with no success

I have a macro that will copy the database to a folder upon quiting. The databse also is enabled from the options to compact and repair upon exit. Problem is the copied databse will be always not compacted becaue the macro will run 1st before quiting (and hence before compacting). is there a...

I am trying to write a code that will enable an event to happen if 2 conditions are true, something like: If [DueDate] >= [CurrentDate] And [EndDate] is Null Then Event ..... take place I tried above and did not work it works only if write one condition of above how can I set it up correctly

I have a switchboard with an exit button to exit the application. I want to add an event so it executes when user exit the application from the switchboard. how to do that. or how can I access the procdure for the application exit attach the event to

Dear all, I have a form with a subform that is linked to a query. the current record Source is as follows: SELECT tbl_Orders.OrderID, tbl_Orders.PurchaseNo, tbl_Orders.CustomerID, tbl_Orders.StartDate, tbl_Orders.DueDate, tbl_Orders.EndDate, tbl_Orders.InovoiceNr, tbl_Orders.Notes...

I managed to insert a graph on my form based on a count query of my orders table. So it display now the number of pending orders (EndDate field is null) How can I make it dynamic i.e. when an Order is no more pending, the graph will automatically be updated. I guess the query has to be...

Dear all, I have a simple query that shows the pending orders and unfinished order detail tasks. I want to be able to count both (unfinished oreders/unfinished tasks) and display them graphically on the main form. I tried the group by and tried to count number of records in the OrderID field...

is it possible touse visual basic 6 for example to create an interface for the finished access database so that I can create an install application for users that do nothave Access. in other words, I want to have a standalone application through VB 6 that will manage the database application...

what is the best way to do it without harming anything. is it also possible to reset autonumbers thanks

Hi, I have a form with a field "EndDate" and a subform holding multiple tasks and each of these tasks have a checkbox field "Completed". I want to write a code that will prompt the user to enter "EndDate" in the main form when all tasks in the subform has been checked (Completed). appreciate...

can I reun my report based on 2 criteria from one query. I learned how to do that on one criteria e.g. date (between and), I tried to put a second criteria e.g. Company name but it does not work thanks for any tip

Hi, I have a form based on a table with a text control storing "Enddate" and a checkbox names "Completed". I want to write a code that will prompt/force the user to enter a date in the "EndDate" field if the "Completed" checkbox is checked. otherwise, it is OK to leave the "EndDate" empty as...

I have a report based on a query that shows Company name, total sales, net profit with a sub report showing detailed orders for that company. problem is no proper page break by company as I want to, so the pages continue and accordingly the 1st page will have the send company name then the...