Recent content by risoam

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