Search results for query: *

Hi, I am attempting to write fields from a form and sub/sub forms to antoher table. I can make it work with numeric values, but not with text. I've tried various combinations like 'text' and "'text'", but can't get it to work. The way it is below, i get an "enter parameter value" popup on...

All, I've read what seems like 100 posts related to rounding problems. . .learned some things, but haven't found quite what I'm looking for. The table fields and associated form fields are formatted to accept the numbers I need (mostly decimals and many less than zero i.e. 0.1655) If I type...

I need some advice on how to get rid of a bunch of spaces in name field. There are 250,000 records and the name field is a mess. The format is FIRST MI LAST with no comma's. The problem is that there is almost always multiple spaces between the name parts. It looks like this: JOHN...

This Expression: Trim(Mid([TempName],InStr([TempName],",")+1,InStrRev([TempName],",")-InStr([TempName],",")-2)) in an update query works fine on my machine. However, when I give the entire database to another user, he gets a type conversion failure. Same access version (2003). What could be...

I am pasting table info from the web into excel. If I do a straight paste, the column formatting comes over clean. If I do paste/special/text, the formatting is messed up. The problem is that each time I paste, excel stops responding for up to 2 minutes before completing the paste. I'm...

I'm working on another list of names that I need to parse into 3 sections (first, Last, Degree. . .they are doctors). I'm having trouble with first name in some instances when there is a suffix (i.e. Jr. or III). The format is always Last Name, First Name, Degree I'm using the following to...

Hi, I'm dealing with address fields which I normally don't have trouble with. . .I'll typically use Left, Mid, Right to pull out the component of the address (i.e. 123 main st, baltimore, MD 20122). Now I've got one that is inconsistent that I don't know what to do with. I need to parse it...

I have found a lot of discussion surrounding this, but not quite what I'm trying to do. Users can create a new record in my dbase. Everything works fine wout problems. What I"m haveing trouble with is after the new record is created, I was to redirect to another page and display that brand...

I have to convert several thousand records from a spreadsheet to a good relational database format. The problem is that the excel spreadsheet is one column with 15,000 rows like so: Name Address Phone Name Address Phone Name Addres Phone etc, etc, etc. . . it goes on for ever. After I import...

I don't even know where to begin with this one! The database deals with audits that are performed usually on a quaterly basis. Each time one is completed, a new due date is added to the table with the new date being calculated three months out. Right now, if an audit is past due, it simply...

Hi folks, I used currentuser() to get the username in my app. Everyone shows up as "admin". Does anyone know the citrix "equivalent" to currentuser()??

I'm so close. . . Private Sub Form_Close() If Forms!Switchboard!frmAllRebatesDue.Visible = True Then Forms!Switchboard!frmAllRebatesDue.Requery End If If Forms!frmVendorMain!frmVendorGen.Visible = True Then Forms!frmVendorMain!frmVendorGen.Requery End If The second form won't requery. . .I...

My tab control is on the main form, then there's the tab "page" then a form and a subform. I can't figure out what is necessary to reference the subform for a requery. Is it Forms!MainForm!tabcontrol!page!form!subform Seems like a lot, and i've tried several variations with no luck. . ...

The form is basically a due-date entry form. User enters date received and an unbound text box (DueNext) calculates the date the report is next due (i.e. 3 months later.) I then have an INSERT statement to add the new due date, etc into the table. Here's the code (on click event of a button)...

Hi folks, I'm hoping this is easy, but I can't find it anywhere. I want to use code builder, but can only access expression builder for a text-box. I wouldn't mind using expression builder if I new the equivalent to this: If [frequency]= "Annual" Then DateAdd("m",12,[DueDate]) ElseIf...

I have read many helpful (and interesting) posts re: sendobject. Can't seem to find anything like this: I want to send an email triggered by a date in a form, but I want the email to be sent 30 days in advance. The database is for contract management, and I need certain people to be notified...

I've read all the posts relevent to my issue, but can't find anything quite like my problem. I used to be able to make this work, then had to replace hard drive, reinstall everything, etc. and now I can't recreate the connection. The Host has VPN enabled. . .I establish that connection first...

I had to replace my hard-drive. . .so many things no longer work! I connect to a client via VPN.. no problem, sends/receives. Then, I have to do a remote connection to the server. I used to be able to do it, but now it can't seem to find the ip address. It seems like it is not looking...

Here's what I'm racking my brain over. The table: Rec# ID Date1 Date2 etc. etc. 1 10 1/1 2 10 1/1 3/1 3 20 1/1 4 30 1/1 5 30 1/1 3/15 I hope this makes sense! I want the query to return records with null values in Date2...

My query results are like so: 1/1/2003 100% 90% 97% . . . 4/1/2003 98% 95% 99% . . . 7/1/2003 100% 99% 96% . . . 10/1/2003 99% 96% 99% . . . I want the report to display the dates as column headers with the percentages beneath, like this: 1/1/2003 4/1/2003 7/1/2003...