Search results for query: *

I am storing settings for different processes in a database. I have a table for my process names. I also have a separate table for each type of dialogue box that could store settings. Not every dialogue is used for every process. I need to compare settings used between all the different...

I have modified a macro I recorded to make it better. However, one bug I can't seem to get rid of is when there is only one column of data it tries to copy all the empty cells in the workbook to the right. I have made several attempts to overcome this, but have only proven I don't know what I...

I have the following code in the Open event of my report: Me.LotNumber_Label.Caption = [Forms]![LotNumberTrace]![LotKey].Text I had this code in my Load event, but it would only run when the report is previewed and not when it was printed via a command from a form. So...I moved the code...

Don't make a field a number, just because you are going to store numbers in it. Because, one day, it just might need to store a letter also. Learning this the hard way, right now. Example: Numeric tracking numbers - sometimes, things get messed up and now they need #####A and #####B. And...

I want my query to only return unique results. I have made acceptable queries using either Group By or Distinct. I read that you can't trust DISTINCT to de-duplicate correctly in some situations. Does Group By suffer from any issues? Is there any other differences that I should be aware of...

Is installing standalone access 2007 with older versions of office bad? There are a couple of computers here with older versions of office and no version of access. So, we could upgrade to Office 2007 pro, but if we have to, is it a bad idea to only purchase/install Access 2007 and install...

I am developing a database for Access 2003 for a small company. Possibly 5 users for the database itself, more with time. Practically, only 2 users at this time. I am only physically at the company for a few months out of the year, and hopefully that will change as they have installed a...

I am setting the default value to the current value like so: Me.Size.DefaultValue = """" & Me.Size.Value & """" Size is a text field which can contain a lot of different kinds of input. The problem is when someone enters something like: I obviously get a #name? error in the control. How do...

I have an append query that adds one record. I have a form which calls that query. I would like to reference the record that is made by the append query. Currently, I am using DLookUp to find the matching record, but this concerns me. What if my logic for the DLookUp gets broken by some...

I have a form and a subform, NewOrder and NewOrderSubform1. The tables for these forms are Order and OrderRelease, respectively. Order has fields OrderKey, OrderNumber OrderRelease has fields OrderReleaseKey, FKOrderKey, ReleaseNumber What I need is to have the field ReleaseNumber in...

I give stars because you guys are greatly helpful, but I just wanted to post a general thank-you. I just got through putting together a real tough piece that's only going to get tougher. After getting that together, I was just enjoying my finished product and was just feeling grateful to...

. TLDR? - see summary at bottom I have a crosstab query which shows a backlog by month and order. The query is great! But, I need it to have totals by month and format orders that have shipped red. So, I thought I'd make a report. Well, you know where this story ends: The number of...

I have already made a work around for this problem, but I would like to understand it - not just hack a solution. I am making a query which groups entries by month and gives me totals. The error I get is: The problem is in this little snippet: MonthName(Month([DateMelted])) DateMelted is...

I am working for a company during the summers making a database. I have no idea who will need to understand what is going on, so I want to make sure it is well documented so if it lands in capable hands it will live. Now, I have programmed in C++, and making documents in code there makes...

I want to have a query that returns all records when nothing is specified for the criteria. The field the criteria is in may or may not have data. All of the expressions I have tried only return any record for records where the field exists - leaving out ones where the field is null. Now...

Hi all, I am having trouble finding the answer to this question, and I think it is because I don't know the right words to use. So let me describe what I want to do. I want to edit the ability of individual users to access files and programs. My end goal is this: I want a guest account...

I am getting the following errors when I open a form: "the expression On Load you entered as the event property setting produced the following error:Return without Gosub." "the expression On Current you entered as the event property setting produced the following error:Return without Gosub."...

I have tried to search for this answer on the internet, but I get swamped with irrelevant results. What is the differences between 2003 server and small business server? And which one should I get? We are a small business with <10 users. We need a server for storing/sharing/backing up files...

I have a form used for data entry. It is for making inventory adjustments. There is a combo box, where the user can select which inventory item to adjust. Now, what I would like, is to have it so that whenever the combo box is blank (either because the user has deleted the information there...

I have two fields which are mutually exclusive. Only one should be filled out always. Never both, never none. Making the two fields one is not an option I will consider, though perhaps it is technically possible. Now I have the form set up to prevent the user from entering data in both...