Search results for query: *

I am trying to push tables of data to multiple databases using a master database. All of the child databases have passwords on them which is fine as I know them all. I am able to create the append query, but when I run the query I get an "invalid password" message. Does anyone know how to get...

I have a query linked to an option group on a form. The query works when I have option 1 or 2 selected, but I want to return all records if 3 is selected, but instead is not returning anything. Does anyone have any ideas? IIf([Forms].[frmQualityReview].[optReviewed]="1","Yes") Or...

I have a combo box that I need the selection options to be sorted. My row source is .xls files from a folder path that I have chosen. I have that working with no problem, but the sort order is messed up. Does anyone have any idea on how to sort this?

I have a search form and when (blank) is selected from one of my fields I am having a hard time getting the query to return all fields that are not null. If nothing is selected, return all records. If a name is selected, match the name. Logic tells me to write it like below, but I know it...

I have a query that is linked to a search form that I am having issues with. I am fine with everything until I get to including a date range. I used the criteria of 'IIf(IsNull([Forms].[Search].[BeginDate])=True,[SubmitDate],Between [Forms].[Search].[BeginDate] And [Forms].[Search].[EndDate])'...

Does anyone know how to link a table and have it use the network drive name instead of the drive letter? I have a multiuser database and the users have the network drive for this database assigned too many different drive letters so I need to use the drive name but I don't see an option when...

I've been stumped on this one for most of the day and can't figure this one out. I have a coworker who has a spreadsheet that the print preview looks fine but when printed the text in one of the columns goes over the gridline and is overlapping some text in the next column to the right. When...

I have a form where I had a field being reset to the original value if other criteria was not met. After a few updates were made to the database this code is no longer working. I am getting an "Operation is not supported for this type of object." error. If I save the record upon entering...

Hi everyone, I'm a little stuck here and hope someone out there can help me out on this one. I have a subform that has dates when an item is closed. Currently the main form has an overall case closed date as well that does not allow a date to be entered until all dates on the subform have been...

I have a report with about 25 subreports that vary in size, none of which are more than a page in length. My issue is that I don't want to have a subreport split on two pages but can't find a way keep keep it on one page. I'm not sure how this can be done with the subreports prior to it having...

I'm a little stuck trying to write code to change a table's description. I found code like this very similar that works fine for renaming queries, but I am getting a 3420 error "Object invalid or no longer set". Can anyone help me out? Dim prp As DAO.Property Dim tdf As DAO.TableDef Set tdf...

Is there any way to align headings in datasheet view? I have a table that has a rather large memo field and I would like to left justify the headings instead of center justify. I have looked everywhere I could think of, but have been unable to find out if this is possible. Thanks

Is there any way to return the min and max of a field based on the Select Top X in one query? I am getting Error 3122 when I attempt to add an expression to find the min/max and can't figure a way around it other than to create a second query to find a Min/Max value from there. I'm trying to...

I'm trying to make an append query to append a set amount of cases data to a sampling table. I am following MaCorr's sampling calculations which in my case leaves me with the formula of, 96.04/(1+(95.04)/[Number of records on my qry meeting criteria]). Example would be if I have 185 records...

I hope I can be clear with what I am looking for. I have a database that has a status field with values such as Open, Pending, Closed. When a case is set to closed it is archived. I need some validation to happen at that point to make sure one or more fields are completed (the record is not...

I have created a database that prints a coversheet that a third party vendor will then enter in their system. My problem is that this is handled in a foreign country that does not know English and they confuse O and 0. I have looked through all my fonts to find a zero font that has the...

I looked for a bit on the boards but could not find anything. I have a form attached to a query and when the form opens it promts for a contract number (from the query). What currently happens if the contract number is not found is a blank record appears in the form. I would like the form to...

Is there any way to change the color of the top bar of a tab control? I can make everything but the top bar transparent, but that grey bar doesn't look too good on my blue background. Thanks Steve

I'm not too sure if this is possible or not so I figured I'd post here after banging my head on the wall trying to figure this out. Is it possible to have form field shading on but not shade checkboxes at the same time? Thanks Steve

I'll try to be as clear as I can as to what I am trying to do. I have a form that is linked to a query. That same query is attached to another form (dialog box) where the user will enter a SSN to search for. That value is passed to the query and will open the final form with all matching...