Search results

I believe the key is to use the two different events: Before/After Update - Only affects updated records : If they are updating capture the current index location and use the goto command to go to the next one in an afterupdate command (or whenever), actually I think goto next will do it...

Actually, ironically, I did have a form requery in the macro and that was what caused the problem (after I added the recordset code). When I was using the recordset code with the bookmark (ie. standard unbound combo-box after update event on a search form) the code was setting the bookmark for...

Wasn't sure how to write that title more succinctly :) Anyways. I have a problem with a form I have. It is set to open using a context menu from a list box. When the form opens a combo box has it's value set to what was selected in the list box. Currently this is done through the brute...

ok....this is a bit embarassing....I may have been referencing the wrong context menu, and may have fixed that..... 1/2 the time simply posting the thread guarantees I will somehow figure it out the stupid thing I did before anyone can answer.

Ahhhhh ok, since I'm only saving it as SQL there is nowhere to save properties. Gotcha. I'll figure out a way to format it in the SQL, I don't like saving queries for stuff like this unless it is absolutely necessary.

Having some problems with a listbox not being selectable. I want it to be set up for single selection for a right clickable context menu. Right now it shows the listbox (populated) and I can scroll up and down, but I can't select the item. All of the properties seem set up correctly. That said...

An SQL statement.

I'm sure this is a simple issue, but its driving me up the wall! I have a query used in a listbox, and I want to format the decimal places slightly differently. I right click the field column, change the format to fixed/decimal places = 0, and then run the query. All decimals are there, and...

I've found that these two small functions do a massive amount for cleaning up the appearance: Public Function DeveloperMode() DoCmd.SelectObject acTable, "Sometable", True DoCmd.ShowToolbar "Ribbon", acToolbarYes End Function Public Function UserMode() DoCmd.SelectObject acTable...

I've recently resumed working on a database front end I gave out to coworkers, and I'm coming to terms that I don't like the overall presentation of the database. Not the forms/reports etc, those are fine. More specifically I am talking about what Access looks like when they open it up and...

UPDATE: SOLVED This was the offending code that caused the unqualified reference (assume all variables are dimmed apropriately): xlsheet.Range(Cells(7, 1), Cells(lastrow, 1)).Value = polyid Which looks like it is a qualified reference to xlsheet, but its not. This is...

UPDATE The problem has something to do with making a "unqualified method or property call". If you do that it creates an invisible reference to the excel application, which makes it impossible to programmatically close Excel. http://support.microsoft.com/kb/319832/en-us Now, I feel I have...

I can't have it save everything. A lot of the files that people open up are raw datafiles. They will manipulate them and do stuff to them, but its understood at the office that you should NEVER save them after doing that, as they are raw datafiles. Hence I can't have them save everything...

wow....yeah I need to get some coffee :P Anywho, there is no way I can have the code make the choice about what is saved and what isn't. Its a pretty good way to have my boss scream at me. Followup. Its working now (was just the break on all errors causing the problem) but I am having some...

I have a program I have written that does a bunch of wacky stuff in excel. Before the program runs though, it is imperative that it runs through and closes ALL instances of excel before executing. This is due to an issue with the files that are going to be manipulated are often open on peoples...

Been working on some stuff that requires me to open a tab delimited text file in excel. I have the Excel scripting library referenced, the basic codes goes as follows (with a couple of irrelevant deletions). Dim StrFilePathB As String Dim fname As String Dim rs As Recordset Dim xlApp As...

I have a database that uses uploaded .txt and .csv files that are generated daily. I have a script that automates the uploading but it is very currently unable to automatically find new files (have to point it to the files to reformat->upload). I would like to have this fully automated. The...

I do a lot of charting in access and I would say the chart wizard is broken pretty much everywhere. This may be mainly because I do a lot of scatterplotting of non-aggregated data, which may be the thing that it is worst at. The legend names are defined by the field names in the chart query...

Yeah, hrm... Ok, try removing the outer join to the tbl_products, make it a normal join, and for the moment ignore any aggregates. edit: ah, yeah I already mentioned that.

I think you do it by changing the joins to outer joins, I think. In the query design window you have tbl_ProjectsChecks related to tbl_Projects and tbl_Checks. tbl_projects will be related to the junction table tbl_projectsChecks through project_ID with an outer join. You can do this by...