Recent content by gguy

I am importing a text file into an Access table from an OnBase system. The text file is the result of an inspection. The text file has 19 fields. One field out of those 19 is an inspection code field and unfortunately, it has varying numbers of inspection codes in that field. Each code is 3...

Hey, just wanted to say thanks for the help. This modification is not real important to the function of this database but it would simplify the database for our management staff that may only get into the database once or twice a year. I would like to send a copy to you to critique if you...

The problem is that we are still using Office 2007. I guess this functionality was not kept in Office 2010. In Access 2007 you can create users and groups and there is no security table that I can see. Correct me if I am wrong. I think I am just going to have to rewrite that portion because...

No one willing to help me out on this one or did I not ask my question clearly enough? Maybe I should have put this in the forms forum because the code will be run from the On Load event of the form that is loaded when the database is opened. I can get the DoCmd to work correctly but I want it...

I have a database with security setup and either by user or by group I would like to inhibit the navigation pane. Like, for anyone in the Admins group I would like the the navigation pane to be available but for anyone in the read only group I would like the navigation pane to be inhibited. I...

Thanks for the replys. The split may not be impossible as majority of these locations are yet to get the program and the modification of the verbage is just a suggestion at this point. I should have said that this program will be at 43 locations. I will search the forum for more information...

I have an access program that is in 43 remote locations. I need to update a form to change some leagle jargon in a disclaimer on that program. I need to somehow send this form to these 43 sites and update the database. Is there an easy way to accomplish this function? The users of this...

Wow, I am embarrassed that it is that simple, some times I get so focused on a code change that I didn't see the obvious. I wasn't using an underlying query I was just using a table. I created a query with a sort and a secondary sort. Works like a top. My apologies VBAInet for getting...

VBAInet, sorry for my curt reply, and I do understand all that you we're saying in your initial post. Look, if you understand the code presented than you would realize that your initial post was just as offensive as my reply. Again, I am asking for help with this code and I have been around...

Thanks for your reply VBAInet but I am looking for someone that really understands VBA and this code specifically. I am not posting to get palaver from Egotistical Access hacks. VBAInet, if you really want to help then do the leg work. Otherwise, don't waste my time and yours. G

I need a bit of help with lookup code The following works well, it brings up a list box by application number Private Sub Search__AfterUpdate() Dim rs As Object Set rs = Me.RecordsetClone rs.FindFirst "[appl_no] = '" & Me![search#] & "'" Me.Bookmark = rs.Bookmark End Sub The problem is say...

Bob, thanks for all your hard work with my problem. I was called away to Texas and just got back today. Greg

Bob, thought this was what you needed. The problem is in the total field called "# applications" on the rptNebraska_Buffer_Strip_Program_Summary Thanks,

On the report menu choose the sixth report "NBSP Summary by NRD" You should be looking at the "Buffer Strip Reports Menu" Choose the 6th report, "NBSP Summary by NRD" That will take you to a form where you can choose NRDs from the list. Choose some NRDs and then click "view selection"...

That took a bit of doing but there is the stripped database. I have been calling NRDs counties, thought it would be less confusing. On the report menu choose the sixth report "NBSP Summary by NRD" By the way, all info in this database is public information. On the list picker do "view all...