Search results

Thank you for the code, it's a good, clean alternative. When I tested it, I noticed it leaves the cursor at the last location, which could be ten or twenty rows down, not a big deal, just different. The code I found really wipes out the contents of the window and puts the cursor on row one, no...

I would like to add an icon to the VBA icon menu, not the Access menu, that can execute a specific procedure. I was able to drag the Macro... "command" to the icon menu but that just gets me the list of procedures. I then have to locate the procedure I want and click on it. It's better than...

I hope this is not too complicated but it is something I do with every database and should be considered when building one. Continuous forms use a query as the record source, editing an existing record is bound to the table holding that record, and new data/records use an unbound form, meaning...

I have also had the problem for a while now (Windows 10 and Office 365) and it is quite annoying. Primarily, I experience it in continuous forms but someone here mentioned that it also happens in tables, so I tried it. With the cursor on any random record, the noise continues, but when I click...

I was wondering if anyone has found a way to grab stock market data since Yahoo has closed up the free access loop hole a few years ago. I have a work around using Excel which links to the data and a simple refresh gets me the latest numbers. I link this table to my investments database and run...

Chuck, I am going to chime in because I think you are focused on reports when you are really asking an application wide security question. If you have confidential reports, then you have forms with confidential data to which only a few people should have access. So, I am assuming you must limit...

I need help with the management of the navigation pane. What I am looking for is the vba code that "rolls up" each group of objects. I don't want to see the entire list of tables, I just want to see the headings of any group that has an object in it. I can use the code below to minimize the...

Yeah, that might be better as it matches the printed forms people are used to filling out. Where did you get the asterisk? I will tell you though, the yellow background really pops in user's faces and they get the message, particularly when they edit a record and wipe out a required field. I...

I am going to throw in my two cents worth because I like my strategy. On opening the form turn the background of the required fields yellow. In the after update event of each field, check the value for something other than null, if met, background turns white, otherwise background turns...

Thanks, found it in the hidden MSysIMEXSpecs table. Always thought it was buried in some deep dark system folder ini file somewhere. Makes my life easier, thanks again.

I am importing one large field from Excel, a string between 300 and 600 characters long and delimited by a semi-colon, which does not exist in the data, so I get the whole enchilada. Additionally, because of the length, I changed the field type to memo, from the default text. All of this is...

yeah, that is in there and the test is successful. If I use link table manager and refresh the tables, the user can open them and see the data. But without the refresh, double clicking on a table gets you and ODBC error. So it that the answer, it should work with the info in the ODBC app?

I need some confirmation on something that I have noticed is causing a connection problem. When I build a front end I am linked to tables on SQL Server using an ODBC connection with the DSN of "BEData". When I send the accde to a client with the same DSN but pointing to their server, the...

Nancy, have you tried any code behind that button? Here is the easiest sample I can give you. Understand you have to make a report in Access first, then it can be "exported" into an Adobe PDF format. So behind that button, enter something like this Dim Destination As String Dim FileName...

MarkK, Wow, you were spot on. I put the report title in the report header format event and the other two in the page header format event and the strings showed up. Thank you very much for the quick response and the report lesson.

I am getting two different results when I preview or print a report. When I preview a report the report title and page title are populated with the strings I built and assigned to global variables. In the report load event the GVs are assigned to the text boxes. Everything works great. If I hit...

JHB, So that worked. Got a menu and all sorts of cool smiles. Thanks. :)

I am making an educated guess here because I have run into a problem with long strings that are queries. The VBA "page" where the code is written has screwed up my queries when they are assigned to a variable and the length exceeds the "page" width. Try this. don't assign the string to a...

OK, so there is the screen shot.

Afraid not. I get the emoticons across the bottom, a title box and logged in as across the top but that is it. I have snipped the screens, but I don't know how to add them to a post. I select copy in Snip, but paste is not a valid option when I right click on this message box. I will mention...