Hi, I was wondering if some knew how to base a queries results on the username? So if JSmith is logged in he gets locationCode=1, if BJones is logged in he...
Hi, when I first made an access database I imported info from an excell database (made the headings and fields match). I was recently sent another excell...
Hi John Thanks for getting back. I'm using the Environ("USERNAME") command, but depending on the user, I want to assign a location code to the criteria on a...
Group, I have MS Access 2K. I would like to know if anyone here has developed a progress meter that is embedded in a form. For example, I have a macro that...
Isaiah- There's a Progress Bar ActiveX control - but you might need the Developer's edition to get that. And you'll need to learn VB, not use macros. You ...
Hi Grp, I have an Access Database which i'm using for more than a year. One fine day i got this error message, and i'm not able to open the form. The Error...
It sounds like your form has become corrupted. Can you restore it (import) from a backup? I suggest you create a new database, import all objects from the...
Thanks, But i tried using the back up file that we had in server. The back up is taken every week. And i also have a backup in my pc. Even that failed. Kind...
Did you install some new software or change your version of Access lately? Is this the only form that is broken? Can you run other databases OK? Is this...
Hi John, I'll put my 50c on some activex control(s) no longer supported probably with a change of version. What do you reckon? Regards Robin. ... lately? ... ...
Robin- Good guess. He didn't say he had upgraded, but that would surely break stuff. John Viescas, author "Building Microsoft Access Applications" "Microsoft...
Hello, This depends on a coupla things. If your database is Access 2.0 and the Excel sheet is 2003 then the database never heard of it before and you'll have...
What are you doing up at this time of night John? I'm just about off to bed myself (it's 11:05 here) Regards Robin ... break ... Access ... databases ... ...
Robin- It's 8:45a here in Central Time Zone in the U.S. You in Australia?? John Viescas, author "Building Microsoft Access Applications" "Microsoft Office...
John, Yup, and while I've got you, maybe you can tell me, is it as easy to hook onto an Oracle database as it is with SQL Server? Regards Robin. ... ...
In theory, yes. If you understand Oracle well, you can create an mdb application using linked tables to Oracle. But if something goes wrong, you won't get...
I'm trying without success to automatically copy and paste a field data in my form to a another table field. Illustration as follows : Table A : Key Field...
Typyically, the code generated by MS Access will appear as below on command button to open form on click : ============================================== ...
Kiang- It is not recommended to store calculated values in your database. Why do you think you need this total in another table? What is the business problem...
Given the following simple example table: ID Product Order date Cost If I wanted to find duplicate ID's, I would write a query like this: SELECT DISTINCTROW...
Kiang- You must execute one DoCmd.OpenForm for each form you want to open. Do close a form, use: DoCmd.Close acForm, "<name of form here>" John Viescas,...
Hi John, I have modified the template of MS inventory control to construct a system control of the activities in our chemistry laboratory. In the template,...
Hi John, I have no problem to open one form and close another form at the same time, but having difficulties to open or close more than one form. The reason to...
Kiang- A particular transaction should be able to add or subtract inventory. If you receive more product, enter a positive transaction. As you use up ...
Pete- Like this: SELECT [ID], [Product], [Order Date], [Cost] FROM [Order Table] WHERE ((([ID]) In (SELECT [ID] FROM [Order Table] As Tmp GROUP BY [ID],...
Kiang- You should never have two forms open editing the same data. I don't understand your problem. To close SHRINKAGE and BUDGET and open SCHEDULE and...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
