Search results

Solved sort of Hi all Built out a work around where I have calculated the date differences inthe first query and have then built other queries from this data. Simple solution in the end, just was not looking at the problem correctly initially,thanks for viewing and the reply. Craig

Hi all I have a problem trying to create a query to count 2 dates in one query. I have recorded dates for the return of forms from specific types of vehicles, the first date is the date the form is for, the second is the date I received it. I have a query that returns the count of the forms...

Hi all I have created an input userform in Excel using the form creator in the VBA Editor. The form has a number of controls on it, Text and combo boxes, Option buttons, and a number of check boxes, in total, around 100 controls. A function I require is the ability to clear the form, ie reset...

Not sure if this has been solved for you yet but I use a form builder that you access from the VB Editor. If you go to Tools>Macros>Visual Basic Editor and open this, then click Insert>User Form. This creates a form which will allow you to interact with your worksheets using VBA. I have found...

Hi Alex As suggested by RuralGuy on my thread, trialling the fixes suggested in the Access help files worked to solve the problem I was having. The form property "RecordsetType" needed to be set to Dynaset(Inconsistent Updates). Once this was done, selecting from the dropdowns worked...

Hi all Thanks RuralGuy, trialling the fixes suggested in the Access help files worked. The form property "RecordsetType" needed to be set to Dynaset(Inconsistent Updates). Once this was done, selecting from the dropdowns worked perfectly, just as I wanted it to. Thanks Craig

Hi all I have been nutting out this problem but have been unable to find a solution, even my learned colleague is at a loss to help. This is an data update query using combo boxes and forms. I have 2 databases, Data and App, I have linked 2 tables, Main and Supervisor from the Data.mdb to the...

Thanks grnzbra, have added it to the SQL statement and it works a treat. The code is below if it helps anyone else out. I changed the 0 to 1 so that it automatically jumps to the first week after the fourth. UPDATE PM_Week SET PM_Week.WeekID = IIf([WeekID]=4,1,[WeekID]+1); Craig

Hi all I want to view vehicles due for servicing in the next week. The queries giving me this information work fine. I have a form that I can select, from a drop down box, either 1,2,3 or 4. A report is then run and emailled to the appropriate people. After testing to see what was the...

Thanks, exactly what I was looking for, just wasn't sure what to search under. Regards Craig

Hi all I have seen some functionality in another database and would like to add it to mine but I have no idea where to start. I was hoping someone would be able to point me in the right direction to a tutorial or sample database that could help me. What I would like to do is record when changes...

Hi all Solved my own problem. I had entered the table I was appending to, to the append query. As a result, the query looked at both tables and entered the data for every record it found matching the criteria. Once I took the Plant_History table out of the query everything worked fine...

Hi all Can someone help me with an Append query problem I am having. The end result I need is a Work sheet that has a Customers details, Plant details, Work required and a Subcontractor name. I have a search function that I use to select either a Customer name or Plant ID. Once I have...

Thanks Banana, works a treat. Has taken a while to get back to this problem but its all better thanks to your advice. Craig

Hi all I have a query linked to a report that prints a worksheet specific to a individual work item. This report/query picks up the Work_ID value on a form. I have 2 other forms displaying the same work with different amounts of detail. Rather than create a new report/query to run from each...

Thanks Neil, works a treat, you learn something everyday. Regards Craig

Hi all I have a query that is getting data fron 2 linked tables. The relationship between these 2 tables is 1 to many. The first table(One side) contains Due Dates for services. I have asked the query to return services for the current date which is working fine. The second table(Many side)...

Hi again Please disregard this post, must of had brain fade this morning. I created separate queries and forms that work in a better order for what I ultimately need to achieve. I got the required result with requiring a subform. Regards Craig

Hi all Simple problem I'm hoping someone can help with. I have a form that is populated using a query that looks up a table called tblFleet. I can search the query results using a simple search function I downloaded from this site(See previous thread). What I would like to do now is display...

Hi all Simple problem I'm hoping someone can help with. I have a form that is populated using a query that looks up a table called tblFleet. I can search the query results using a simple search function I downloaded from this site(See previous thread). What I would like to do now is display...