Search results

Hi Folks, I haven't been on very much recently due to being moved to a new position at work, I hope ya'll are well. :) To the point. I have a form where in the before update event I have the following code (ByPass is declared public to the form at the top of the vba window as an Integer)...

Hi all, I am using an example of a treeview that I obtained on this thread. I learn by doing, and fixing things as they come up. In the code for building the tree view is a union query which I modified how I thought it would fit my needs. I start with a query instead of a table for my...

I wish to have a treeview on a form which displays Categories then Subcategories then a list of errors, for instance: Sales Errors Product Errors Entered the wrong product on the sales order Pricing Errors Entered the wrong price on the sales orde Price should have been...

I have a dilemma. I am trying to concatenate records in a table to display on a form or a report. I have figured out (using a function I found on the internet) how to concatenate the records for display. However, I need to attach the date to it. For instance: AN Date Note...

I thought that this was neat, and as there have been other similar posts, I thought I would share this one with ya'll http://news.yahoo.com/s/ap/us_sci_space_blob

I have a spreadsheet where I use vba to create a pivot table, then change the positions of the columns in the pt. The problem I have is that if the spreadsheet does not contain a specific value it errors (Error 1004). I found code that claimed to check this and that the method was common, I...

I have been asked to create a report for our purchasing department. I need to total up weights for this report, I have some criteria that I have to meet to do this. My options are to use either the actual material weight OR the weight we debited our vendor, which can vary from eachother for...

I have a data table on one sheet, and a pivot on the next. When I click something on the pivot table I want each recrod in the data table to be examined for a matching number. I have this portion figured out, what I can't figure out is how to find the last row of the data table for my...

I have a subform that I need to filter with the idea that I will use the data in the subform to perform a mailmerge. I thought about using a multi select listbox, but there are literally hundreds of records, so finding the records that are wanted is a challenge. The idea is that many (25-30)...

Has anyone (in excel 2010) come across an issue that whenever a new row is inserted into a spreadsheet a row further down expands to a width of 409? This bugs the heck out of me, and I don't know why it does it. I googled it and I can't seem to find anything except how people want to set the...

Hey all, I have a wierd thing going on, when I swith my form into design view it moves off the screen, I have to scroll all the way to the right and down to see it and drag it back into its proper position, has anyone ever had this happen to them? And if so, what was your solution or cause of...

Hi All, I just moved my tables to an SQL server, and linked my tables to my Access 2010 front end. In this db, I have a table for error logs, and used code I found on Allen Browne's site to log errors. It worked fine when the tables were in Access, but I get an error now that the tables are in...

My boss and I recently had Office 2010 installed on our computers. In XP he was able to set the directory that popped up when he clicked the "open" button in excel to the drive he wanted to use (as opposed to, say, "my documents") I have never done this, so I don't even begin to know where to...

I'm curious. The IT department just installed Microsoft Office 2010 on my work PC. I have created a new DB to play around with. At the top of the access screen it gives the following: Database2: Database(Access 2007)-Microsoft Access Shouldn't it say (Access 2010) as opposed to (Access...

User rights access 2003 What is the best way to set what a user has access to? I am getting a list of all user names from my IT Department. I thought about using the access user security, but I have read on the internet that it is obsolete in later versions of access. I have also heard that...

Hey Guys, I am so excited, we just had an employee meeting and we are getting Office 2010..... I am super excited to work with it.... I hope it's not too hard to convert my dbs over. - I just thought I'd share a little of my joy. :p

Using code that I have found through searching, I have set up a general error handler for all of my code. Fortunately I wasn't so far into my programming as to have too many procedures to add it to... My question is, is there any way add a clock to add comments to, and the error handling text...

I have two comboboxes on a form. One combo-box to find a particular record on the form, and another combobox which looksup values in a different table and places the pk into the fk of the table the form is bound to. This second combo box contains a list of vendors. My user may need to add...

Item added during "not in list", combo box display, form does not jump to record I have a combo box, this combo box uses the "Not In List" event to add a record to a table if that record is not already entered. The event works great, but after it is over, the combo box displays the new number...

I have a query, this query pulls its information from a form and returns ONLY one record (which is what I want it to do), This record is then displayed in a listbox (listbox is based on the query) because it looks nice, on the form and verifies that a record has been found, I want to use the ID...