Search results for query: *

I found one way to do it. iif(isnull([form].[fieldname]),[tablename].[fieldname],[form].[fieldname]) This works but it seems a bit slow...

I see, but I have a few fields that this applies to. Can I do this in an Access Query? Or do I have to build it outside of it? Thanks.

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...

THANK YOU!

Yah I did notice I missed a line: Public Function mySuffix(suffix As String) As String If CInt(suffix) < 100 Then mySuffix = suffix Else myChr = CInt(suffix) - 100 If myChr <= 26 Then mySuffix = Chr(96 + myChr) Else leadChr =...

THanks but actually what I am trying to do is based off of the vaule in the cell which is a number, I want to return that number if it is less than 100, otherwise i want to return a, b, c... aa, ab, ac... that is what I am trying to accomplish. It just seems that Excel isnt recognizing my...

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!

Good idea! That did the trick, 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...

Thanks all for your help.

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.

Thanks for responding. Each worksheet goes with a different letter.

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...