Search results

Thanks Galaxiom, I will study,decipher and digest , and then maybe ask some dumb questions :) Cheers for this. D.

Hi CJ_London, Thanks for the reply and help, that all makes sense to me now. I have tried to implement the changes but I think that my current set of forms that relate to that part of the DB are so messed up with previous attempts to get things to work, that I'm going to make a copy of the DB...

Hi CJ_London, Thanks for the reply, I think I understand most of what you said ! Just to clarify (I knew my description was a bit iffy) The search function is handled by a separate form, when the search button on that from is clicked it opens another form which shows the relevant records...

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...

@smig right i'm with you, I think I understand the basics of Trim now. @MarkK yes I have used Nz as well , in fact now that I have had the time to look back through my code, I have used if Nz (field) <> 0 then , as well as if Len (field) = 0 .. it's all a bit of a mess !! I guess this is the...

Huh ! now your just messing with my head :D I will look up the Trim function later and see if I can get my head around it. As at the moment looking at that, it looks to me that the logic is saying will always equal "" ? Yeah .. I'll read up on it first !! Cheers Damob

Ah yes .. I see, yes thank you mh123 that did help indeed ! Cheers Damob

Re: Having problems with using DCOUNT (Fixed) One last question about this routine .. On the search form for this routine there are 3 buttons, the one that runs the above VBA (which now works perfectly) , one button that is called "Clear" and one that is called "Cancel" Cancel just exits out...

Thanks guys, that fixed the error I was getting, but it still wasn't working as I expected .... that's until I was staring at it thinking my logics all F'd up somewhere, and then I saw it !! :banghead: Private Sub Search_Click() If IsNull(Me![PCNumberIn]) Then MsgBox "You Must enter a PC...

Thanks for the tips, it does help me to see an example of code and how it is supposed to be formulated, to understand it better. And I thought my indents were not bad !!:rolleyes: must do better :) Right onto the VBA ... I'm getting an error .. If I type in a value that I know does not exist...

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...

Thanks Galaxiom, I will indeed read up on 'transacted bound forms' sounds like it is what I need to be using in this instance. Just got to finish off the unfinished modules that I haven't touched for a while, in fact iv'e not touched this database at all for at least 6 months so it's taking me...

OK Thanks chaps for your comments, And as ever you have made me think of things that I may not have thought about before going down this road (Multiple users working on the same record - Although in this case that wouldn't be the case) The particular issue with this form that i'm trying to...

OK - Thanks JHB - I was hoping that wasn't going to be the answer, but had a funny feeling it was the way it is ;) Yes I agree in some forms I want the data to be updating live, in others I don't. Just wish I could have the option tho !! live data updating isn't very numpty proof, that's why I...

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...

It's only test data, not a live database yet, Think i may have resolved it by sorting out the other issue with my SQL statements. Thanks for you input . Damob

OMG I'm a Divide by zero :banghead: I have no clue as to why I decided to use the SQL UPDATE statement, I guess because I had spent a day figuring out the SQL INSERT INTO statement I thought that's the way to do the next bit ! - wrong :rolleyes: When you said "Typically you would do one or the...

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...

OK here is the full-ish description : StockData table contains multiple columns of which I want only a few to go into the repair table. RepairData table has 4 fields taken from StockData (PC number,serial number,type etc) and stores extra fields for repair information. Workshop form has a...

Thanks for that, yep i'm already using the debug.print but it's not giving me any clues as to why things aren't working. Basically the last two fields that I am trying to update, which are empty before updating, will not save, the second from last is a date field, and I am just now swapping it...