Search results

Hello all, I had a form that was a split form type with the datasheet at the bottom .. But I didn't like it as I couldn't get the main form to resize, it always filled the screen, I think because the datasheet was always wider than the screen. So .. I redid the form, and used a subform...

Hello all, I have this little bit of VBA that essentially: A) checks to see if the user has actually entered a value into the input box B) then uses DCOUNT to check the query used, that there are any records that match and if so : C) Apply a filter to the subform datasheet to show only the...

As the title says, this is probably a silly question for all of you experts: One of the things that I really dislike about the way access works is the way that it updates in real-time fields in a table that are on a form. As an example I have : table - query - form , now in said form there...

Hello, I am working on some forms and using a few runSQL statements (I have another post about this) and am using test data in a table that I keep on deleting re adding and editing via the forms + SQL statements, but every now and again (has happened 3 or 4 times today) suddenly the data in the...

Hello, Quick question: When you do a RunSQL Update "tablename" Set Field1='" & Me.text1 & "', Field2='" & Me.text2 & "' etc etc , do the field names need to be in the same order as they go in the table, and what happens if you are only updating say the 2nd field 4th field and the last two...

Hello all, Just wandering what people here do about testing your Access DB's on different screen sizes. Other than physically using a 17" monitor or using VMWare or alternative, is there any monitor emulators out there ? I've done a quick search, but it looks like there are plenty of web apps...

Hello, My access has just started to do strange things :eek: When I close a form after making changes, it now doesn't ask to save. It does appear to be saving, but just doesn't ask if I want to save !! I've been working on a database all day, and it's just started doing this half way through...

Hello, I need to make the text size smaller to fit everything on the screen (users use 17" monitors.. grr!) I have gone into each form and subform and changed the text size for each text box to 9, but when I view them in form view the size has not changed ? Am I missing something really...

Hi all, back again ! I have had to put my DB on hold while working on another project. Just trying to finish things off now. I couldn't really find the right words to describe what I want in the title ! So.. what I have is a password entry popup, it's very simple and there is only one...

Hello all, I want to be able to use the Count function that will reside in the header of the main navigation form that will count the records in each navigation sub form (of which there are 6 sub forms) Each sub form has the same primary key which is what I am doing the count on. I have done...

Hello all, How would I go about writing some code to highlight the current day if a day field in a form matches. i.e. I have a schedule form that has a field that has the day manually entered, so Monday, Tuesday etc. And on the top of the form I have a text box set to =Now() and the date...

Hello, I am trying, and failing quite spectacularly to create a single query that will contain multiple expressions on the same field. Please see attached jpg for example. SQL: SELECT Count(StockData.status) AS FaultyPCs FROM StockData HAVING (([StockData].[Status] In ("Waiting Repair") And...

Hello, I have searched through this and other forums for an answer to my puzzle, but so far everything I have found is overly complicated compared to what I want to do !! Basically what I want is to be able to display a total count of a particular product type into a single text box, so that I...

Hi all, Hope there is not a maximum amount of questions I can ask on my first day !! Also sorry if this question is not in the correct sub forum. Right what I am trying to achieve is this: I have a search form that has 8 criteria fields, of which the user can fill (from combo boxes and txt...

Hello all. Just a quick question . . . Is there a correct / preferred way of opening one form from another and then going back to the original form ? Should it be: DoCmd.OpenForm "new form name" DoCmd.Close acForm, "original form name" or DoCmd.Close acForm, "original form name"...

Hello all, I am pretty much a beginner in Access, although I did create a few basic databases with access 97 a long time back ! I am trying to create a database to manage IT assets, most of the structure is done, I'm now trying to get the details done. The issue I am currently trying to tackle...