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

works great, thanks master

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

Thanks Bob or allthe time you put to help us. to b Honest, I gave up and decided to let the user do it in 2 steps, one button to compact and another to backup. in Compact button click: DoCmd.Close SendKeys "%(TDR)", False SendKeys "%(TDC)", False in the backup button, I put the usual...

OK here is what I did: (1) table created with field names "Comapcted" with yes/no (2) standard module tohold the Comact funaction wher I put the code to set the flag to false ebfore the sendkeys %TDC. to set the flag to false I worte tbl_BUFlaf.Comapcted = False (gave a an invalid...

I never used DLookUp before, so here is my trial which is obviously wrong because it gives a compliation error: dlookup ("[update]", "BUFlag", "[update] = 1") I assume I need to use an IF statement after above (when written correctly) to check for the value whther 1 or 0 then execute the...

Wow, despite bing a beginner, I think I fugured out the above and can try. However, I have no idea about the flaging issue, how could it be done

OK, I am using Access 2003 I put the code in the OnClick event of a button so it looks like that: Private Sub QuitButton_Click() On Error GoTo Err_QuitButton_Click SendKeys "%(TDC)", False Dim stDocName As String stDocName = "mcrBackupFrontEnd" DoCmd.RunMacro stDocName DoCmd.Quit...

Bob, you have been alwaysof help to me, but I tried your above code before and it did nothing (did not compact the database). then I changes False to true (I do not know what False will do in this code so I tried to change it), then I got the warning that you can not compact a database when...

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.

rate is set at 400

same issue, I am not sure why

when i disable it, the record count appears normally

I tried it also, same message. so how is Access is compacting and reapiring upon exit (when you set it up to do so automatically from the databse options). how can we do so then run the backup macro???????

thanks, I tried it and gave me a message that you can not compact the open database while running a macro or visual basic code. I saw in the macro an action option to comact the database. Is it safe to use and does it do same thing as compact and repair (repair part is missing)

yes, they are the standard navigation buttons version 2003 yes I am using the form on timer event to flash the control