Search results

They aren't vb message boxes - the three things that pop up are: 1. Select Query (this just selects 1 record, the one being entered by the user 2. Report (produces a document based upon the new record) 3. Messages reporting the report is being output to file I understand I can probably hide...

Hi, I have a button which runs some VB, it brings up various message boxes as it prints a report to file, runs a query etc etc. I am hoping to display a basic form, which simply covers most of the screen and states "Please Wait" or something. I have already built the please wait form...

Hi, I have found a solution I am happy with - please close this thread.

hopefully I am allowed an edit... I have created the following which produces the mail merged document: Private Sub Command43_Click() DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenQuery "qry_cp_permits_record_to_merge" DoCmd.Close acQuery, "qry_cp_permits_record_to_merge"...

Probably doing your work for you: I am guessing you want a button to run an update query using the "item" field in both tables. The SQL query would be something like (auto-generated after I used the GUI): UPDATE log INNER JOIN setup ON log.item = setup.item SET log.amount =...

Hmm, I think it is the excel files producing the error if you have created multiple front end's. I know you can do the following: http://www.techonthenet.com/excel/questions/shared.php That may help - I am afraid I cant really try it just now.

Hi, I am looking for some advice, best practice or guidance. I have a form, which the users obviously enter data onto. When the data is entered the click a button which runs a macro. The macro saves the record (which produces an ID displayed on the form), then it runs a query which is output...

Is it possible to have a form in access which is always visible - say on the left of the screen - then if a button is pressed alternate forms appear on the left?! I realise I could create one tabbed form with a menu on the left and sub-forms on the right but I wondered if there was another way...

Hi, I have a VB module in one of my databases..it contains a few parameters, variables etc etc... My query -> If I create a form with a few textboxes on, I want to be able to display the variables from the VB Module and all the users to update these? Is this possible or is it better practice...

maybe try going through these to see if any of them apply: http://support.microsoft.com/kb/306204

I can see the value's of the textboxes at run time - the report produces them correctly. I tried using a breakpoint and it simply didn't complain. The problem seems to stem around the fact the report can't see the text boxes ( I think...)...yet I am running the event within the format of the...

I just tried again with the following code - nothing happens but the report opens without error: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.txt_app_scores.Value > Me.txt_orig_scores.Value Then Me.rect.BackColor = vbGreen Else...

Hi, Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.txt_app_scores.Value > 1000 Then Me.rect.BackColor = vbGreen ElseIf Me.txt_app_scores < 1000 Then Me.rect.BackColor = vbRed End If End Sub In reality I want something...

Hi, I have a report - tried a lot of different ways, tried searching the web but I am clearly not getting something..... I would like to turn the back colour of a rectangel red/green depending on the value of 1 of the textboxes for each record. If the value is higher than another text box...

the dirtiest solution I found was to open Access Options and change the "default database folder" - this allowed the attachments dialogue box to open where I wanted....this is a temporary work around. the code is more along the ideal solution. I currently have the following code, borrowed from...

Hi, Using an attachment field - can we specify the location to search? We have an Access 2007 DB and need to attach files from only 1 location - we hope to attach a copy of these files into the database effeciently. I have a few sample DB's that use VB but I am hoping there is a quick and...

I work in IT but my access knowledge is fairly limited, however I would probably use Access. You can create the project in either excel/access but considering your question a database is the way I would go... In excel it would work but not as well. Filters etc. You basically want to store...

thanks... i was hoping I could avoid using more queries...is there anyway to incorporate the percentage using the data in a report!? I know I can use a total record count for one of the values, but can you count another conditionally? That way I don't need 4 queries for one report...If there...

I assume there is no field you can select certain data based upon...? i am guessing that has been thought of...

How big is the physical size of the database? I assume you used the compact/repair to reduce the physical size a bit (you can always manually copy the db file when not in use to make a backup)