Search results

Right, i guess before i go on to mention exactly what the issue is, i'd best just explain that i have spend days trying all kinds of different possible solutions to sort this issue and have researched this no end, but not yet found a proper solution. Ok, so here is the situtation i am in. I...

I have been looking around on the net for a while trying to find out how to do this. I have found, so far, the following: Application.CurrentDb.Properties("AppTitle") = "my database title here" Application.CurrentDb.Properties("AllowFullMenus") = False...

Right, you'll have to excus me if this is hard to understand, but i have done my best to try and make this as clear as possible to understand. I have a form with multiple Tabs. On each tab is a subform which links to a continous form with a query that selects jobs with a specific status from a...

Ok, this may or may not be a large problem. But I could do with some help either way. I am in the process of designing a medium size database, but i am having trouble working out exactly how I should set the Keys for the database and tables. The 2 diagrams below, ER and DFD should help explain...

Right, so i have a table which hase pricing information, and i am trying to do a DLookUp in it to find the Unique ID (MixID) for a given Mix (Mixes). So, i wrote a subroutine to do this and set values for me, but despite the huge number of DLookup's already in the whole project (well over...

Right, so those of you who have seen my question in the other thread in the forums (Link here) will have seen the form in which this code is for, all be it a completely different problem. The problem here is the line coloured Red in the following code. When running it, it stops on the red line...

Having a strange error with a SQL statement in VBA. I'm trying to update an additional form via SQL and getting the dreaded "Enter Parameter Value" issue. I can't see why though especially as some variables are working without issue. I'm using a bound form so the data is saved to a bookings...

I now have a new and simple (ish) problem that needs solving, however, i think it involves a fairly complex solution. I have a form as shown below. That should describe most of the basics of the form. Here is the problem: You can use the navigation buttons to successfully go through all...

I have searched and search and I can't find the answer to this question when I thought it would be simple. Hopefully you can put me out of my misery! I have a access 2007 split form with a series of search boxes and a query result window. Enter info into one or more of the search boxes, click...