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 "Product Number Info", subform "Product Images". 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.