Search results

Hi, I am back again looking for some help. Never encountered this before but have a new user that opened my database(accde) 10 times, and it made a bit of a mess of the data entry(nothing major and fixable). I would like to prevent this happening again. I have been trialing bits of code all...

Hi, Looking for some guidance as I am not really sure how to handle this. I have an event on my form with a loop, and I nearly have everything perfect (well in my eyes J ). I am not sure how to refresh/reload my form from within my code. The code below is what I would deem a successful event. '...

Hi I am hoping someone can help as I seem to be stuck. I have the database 90% of the way to where I want it but I am stuck on some VBA that I want to trigger when 2 controls on the form are equal (outlined in red in the attached image). When these 2 controls are equal I want to change a field...

Hi, Just wondering if I am going the right way about this and if someone could point me in the right direction? I have a main form and subform. The main form shows the master quantity e.g. 80 and then the subform shows the individual boxes of 8. Can I get the subform to filter to show only 10...

I am really stuck and can't find an answer for this and would appreciate some guidance. I have a field in a form txtQtyTray and if I have a numeric value in that field my VBA code below works. If Me.txtQtyTray.Value = Me.txtCount.Value Then MsgBox "Full " & Me.txtQtyTray & " is equal to " &...

I know (I actually don't :)) it is somthing stupid. I had this DLookup working but for some reason now it isn't. When it was working I had me.txtSerial, but with tiral an derror and other fourm suggestions it has changed to below. If DLookup("[Serial Number]", "[tblPassed]", "[Serial Number]...

Good afternoon. I am hoping some one can help, as I am at a complete loss. I have tried searching for this, but its not the easiest term to look up as it pulls results about counting combo boxes etc. I have being trying queries and count loops but with no success. I am trying to create labels...

Hi, Hope someone can point me in the right direction. having trouble coding. Have a text box on a form (txtNoLabels) that determines the no of copies of a report to print. The problem is I cannot get the report to print out the number of desired times using DoCmd.PrintOut Even if I replace...

I hope someone can point me in the right direction. Not really sure what sort of function I need. I have a table with order numbers and po numbers. Some of the order numbers can be matched to one or multiple po numbers. I am trying to group orders with the same Order number and po number to the...

I know this has been asked before but I have hit a :banghead: with my searches.We have an old datalogger that stores data into an access table in OLE format. The field displays "Long Binary Data" I presume the stored object is some sort of image file as the datalogger software displays a graph...

First of all, apologies if I am posting in the wrong section. I am not sure if this is a report, VB or query question. I have a database that track projects. Each quarter I have to generate a bar chart showing total number of projects at each stage (there are 5 stages). Then I have to break...

I am stuck with a bit of coding, that should be easy but cant figure it out. I have a module that exports a query to XLSM and another that runs a macro in the XLSM and saves the file as XLSX. All is working but, the file doesn't automatically save unless you click yes. You get the warning "The...

Hi, I know there is another thread currently on this, but I thought it best to start a new one. http://www.access-programmers.co.uk/forums/showthread.php?t=284027 I have a very basic database, a query, form and a report. On the form there is a combo box used to filter the form. When you open...

Hi, I know this should be easy, but I am going wrong somewhere. I have a form frmStockTake and a subform sfrmStockTake. I have several combo boxes on the main form that the user selects to filter the subform via a query. This is working as I want. My problem is I would like to ad preferably a...

I am trying to figure out how to validate some data if a user chooses to save a record. On my form I have this as my before update event If MsgBox("Would You Like To Save This New Record?", vbQuestion + vbYesNo + vbDefaultButton1, "Save This Record ???") = vbNo Then Me.Undo My question is...

Hi, I would appreciate some input on this, I have a Graph that uses a crosstab query to generate the data. Its only a simple query. One of the fields is project type, but in the query this changes to a number instead of text? I would like to have this as text but don't know how to go about it. I...

Hi, I have a query that is wrecking my head, it is the format of my query that is my problem. I have a form that a users has an option to select a trainee name and filter the data, now I want to add a start and end date, sounds easy but no matter what I try, my query is showing all the results...

Hi, I have a report that contains 5 graphs, one for each day of the week. I run this report daily. When I run the report on a Monday, only the Monday graph displays data and the other graphs are blank as there is no data for that day just yet. Is it possible to hide these graphs if there is no...

I am hoping someone can point me in the right direction? I have searched but cannot find a similar request to this. I Have a table with 15000 entries. This table lists components we use. This table is used to generate queries/forms. I have been asked to add a hyperlink to this table to link...

Hi , I have being requested to create a from that displays the number of files in different folders. I can accomplish this somewhat with the code below. In the example below it is only showing the code for the first 3 folders. I have 7 folders in total to count. I have 2 problems that I hope...