Search results for query: *

I am trying to write a query that reads data from one tables based off of criteria on a form. All of the criteria fields are optional. If no criteria was specified then all records should be returned. Any and all criteria is optional and should return all unless specified. Does anyone know how...

Can someone help me with this: I have an excel spreadsheet that I am trying to write some code for: Public Function mySuffix(suffix As String) As String If CInt(suffix) < 100 Then mySuffix = suffix Else myChr = CInt(suffix) - 100 If myChr <= 26 Then...

I have a stored procedure: CREATE PROCEDURE dbo.MVEMS_BACKUP AS declare @dbbkpname as varchar(40) select @dbbkpname='d:\ftp\myfolder\monroe.bak' backup database MVEMS to disk=@dbbkpname GO that backs up my database. How do I make it so it doesnt append to the backup file? Each backup keeps...

I am using access to make a data file to update a system. In this file (it will be a text file), I need to insert a high bit ff hex character. Does anyone know how to do that? Thanks!

I have a form that has a tab control and on each tab control &quot;tab&quot; I have a subform. The main form has a recordsource of a table that all of the subforms are dependent on. The main form has a hidden ID field that all of the queries for those subforms use as criteria. It works great for...

I have a form that has a tab control on it. Each tab has a subform on it. Tab 1 has names and some information. Depending on what Tab 1 says, I want all other tabs to correspond to it. I have a key that links all of my tables together. What would be the criteria that I can use in a query that my...

Here's my problem. I have an ASP based website based off of SQL server. The webhost does not provide an automatic means for me to backup my own database. The schedulig feature in the SQL administrative tools are disabled for some reason. The webhost was grateful enough though to set up an FTP...

I have an active server page based website that is used for scheduling of an EMS department. The site is hosted by a web host company. The backend database is SQL Server 2000. The web host set up an FTP account for us so that when we backup the database itself, we can FTP in and download the...

Hi. I am trying to set the contents of a cell to bold, if the contents of a different cell = xxxx. I know how to use the if statment, but is there any code where I can set the properties of a cell to bold like that? or even to change the font color or cell background, anything? Thanks.

Is there a way to automate a MS Word mail merge from an Excel worksheet. I have a workbook with about 8 or 9 worksheets in it. Each worksheet is a name and address of someone who a letter needs to be sent too. I have 8 or 9 formatted word documents with the mail merge fields already in place...

I have a bunch of append queries that the end result have the same data picture so all append to one output table. Instead of me having to manually run each query, I have made a macro to just go down the list and run each query automatically. It seems that sometimes the steps in the macro go out...

I split the tables from my database because it is a multi-user database and put the split tables onto our network. There are 3 users all together and the network is very responsive. Ever since I split the tables out, the database is very slow. Forms take a few seconds to load and its just all...

I have a query that I may or may not want to specify a date range criteria depending on whether the date range fields on the form are empty. I tried using and if but that didnt seem to work. Does anyone know how to do this without using multiple queries?

Hi. I am trying to run a query based off of some information taken from a form. As part of my criteria in the query, I have: IIf([Forms]![reports_menu]![Option5].[value]=True,&quot;&quot;,IIf([Forms]![reports_menu]![Option8].[value]=True,([projects].[project_actual_end]) Is Not...

I am trying to populate a form field (user) with a user_id that links to an NT account. Is there a way I can get the logged in user account to the machine to cross reference in my user table to get my user_id number to put in the field?

Does anyone know of a way to find the last cell and column that is being used in an excel worksheet?

I have a table of names and addresses where for each record, there may be 3 more records of the same person just spelled a little differently. For instance, record 1 may be John Smith at 120 Tree Rd. Record 2 may be J Smith at 120 Tree Rd. Record 3 may be John Smith at 120 Tree Road. I am...

Hi. I am looking for a way to automatically import a delimitted txt file using a specification that I have already created by clicking a button on a form. Has anyone ever attempted this? Thanks.

I am trying to use the chr(219) from an ascii table to put a filled box character into my report. I cant save that character into a table and when I try to print the chr(219) I get some awfull character instead.

Hi. I am tying to change the font color of each row on my report. I can't use the conditional formatting because of the Access version. I have one field of data that is my record per row and it spans the entire field. When I right click it and go to properties, I don't have an OnFormat option...