Recent content by jojomore

Thanks PHV, that worked like a charm! Here's a star for ya!

I made some minor modifications to my statement, and it works fine in a query, but does not work on my form: =IIf(InStr(1,[Grote_INTCHG].[GROTE INTCHG],"-")<>6,[Grote_INTCHG].[GROTE INTCHG],Left([Grote_INTCHG].[GROTE INTCHG],InStr(1,[Grote_INTCHG].[GROTE INTCHG],"-")-1) &...

In Access 2000, I am trying to populate one field based on the input from another. The ORIGINAL field would be in one of the following formats: 64532-3 84-1234 45123 For the REVISED field, I need to strip the "-" out in the case of 64532-3 only, so resulting data looks like: 645323...

Hello, I have a csv file that contains new records that I need to update an existing table in an Access 2000 database that I have inherited. I want to automate the process, these are employee records and the csv file is updated weekly. I want to import the data then run some queries to update...

KenReay: The Master/child links are there. The forms work for existing records. rollie@bwsys: I guess I do need a sample...the following is the code that I came up with when adding the add record button to the main form and trying to add your code. The underlying tables have a one to one...

I have a form/subform that I want to use not only to display related info (which works fine), but to add/edit records. The main form is &quot;Product Number Info&quot;, subform &quot;Product Images&quot;. When a new product number is added to the main form you have to re-type the product...

I am having the same problem with some forms that I am trying to organize with a Switchboard. What do I need to look for to fix the forms to default to datasheet view? I have already set the individual forms to allow only datasheet, and they open fine from the database window. But when I use...

Have you resolved this issue? If so, please let me know how you did it. I am having the same problem. I want the forms to open up in datasheet view, and have set all the defaults that way, but when I open them from the switchboard, or even from another form (if I open with a control button)...

I need help with a solution to capture 11 pieces of data from a Meridian ACD... Right now I am capturing all output (hourly) into a text file, which is then copied to a network drive so customer service can access it and then the specific data is being re-entered into a spreadsheet for analysis...

Have you looked at the printf command? You should be able to: printf &quot;password\n&quot; | ndsbackup cf /data/bak/`date +%y%m%d` -a adminnamehere