Search results

I not that experienced with access, but I think you make the problem larger than it is. Problem: I have a value in the form, example XXX, and want a button so that XXX is filled in ALL rows below when I click it. The form has 3 table sources, tblQuestion, tblAnswer and tblUser. XXX is going...

Thanx a bunch. It was missing a ' You rock!

I havent had any troubles with date/time before, and I have just plenty of modules and functions from "other" languages in the same db without any trouble. Could it be a problem with the ' or a " or ¤ % "#¤%!#"¤!"!% or something like that :-) strSql = "INSERT INTO tblFormLog ( Username...

Hi. I get a Run-time error '3075' Syntax error in date in query expression '"23.10.2007 09:05:59#' The tablefield for timestamp is date/time (long date with the same format as the message above). It higlights the CurrentDB.execute strSql The code: strSql = "INSERT INTO tblFormLog (...

I know you can make queries that does this, but I havent managed. I thought it would be easier to di this directly in the form with Vb (now I'm not so sure anymore). I have trieed to explain the structur below: I have a query as the datasource for the form, and its only one active agent from...

Hi. I have a form with 80 - 200 rows of questions. The Questions has a field for username/agent, that the supervisor manually has to enter because of the way the db i created. How can I make a makro/function or something to automate this. Se the attached form for further explanation. I was...

Writing username to table onOpen and onClose in a form Hi. I am trying to make a log of all the different forms in my db. It is for statistical usage only, to se which forms that are often used, and which forms who are never used. Allen Brown has a great audit trail, but I cannot implement...

Its probably a queryproblem. Check the datasource for the form. Se if you have any expressions in the query thats missing a ( or a [ or something like that. Example: Field: ([field1+[field2])/2

How about making a crossquery. You have the employee as rows, the qual as columns and a qualcount as data. Qual1 Qual2 Qual3 Qual4 Emp1 1 1 1 Emp2 1 1 1 Emp3 1 Emp4 1 1 1 Sum 2 3 3 2

Check tools-startup, uncheck the option "show database window" (or something, I have a different language). This is not particulary secure, but removes the window for the common user. To view the window, press F11, or View, than show databasewindow.

Hi. I operate with 2 different DB's, db1 and db2. Db2 is used for enabling/disabling shiftbypass in db1, backup/compressing functions, loggfiles etc etc. On the onload of the switchboard in db2, I would like to check if shift is enabled/disabled in db1, and show the result as an image (a lock...

Hi. Your design does not support many-to-many, a student can bring more than one book, and a book can probably be brought by many students. A course probably has more than one student, and a student probably attends more than one course. I have added 2 tables in your db, and changed the...

hi, I have a loginform that works great, but would like to add a criteria so that the admin user opens a different splash screen than the "normal" user. I want the adminuser to open the form "sentralbordadmin", not the usual "sentralbord". I have no idea on how to do this, and hope someone can...

How, or were do I do that? Now it's written in the after update event of the combobox. (and why does testID 8 work, but not the others???)

I have a mainform (frmQuizScore_begge) with 2 subforms for answered quizzes, and not answered quizzes. I the mainform I use an unbound combobox named txtCriteria with rowsource: SELECT QryQuiz_testliste.testID, QryQuiz_testliste.test FROM QryQuiz_testliste; Testliste shows the different...

Hi. I am creating av quiz database, that are supposed to handle about 50 users. It's about 50 questions, and the answers will be long, more than 255 signs. I have som issues on how to go so far. The quiz respondents will answer in a dap (or maybe Asp) web page on the intranet. The structure...

It's easier to check if the domainuser has access than creating a full login form with DAP. The code below checks if the domainuser has access to your db. You define in a table which domainusers that should have access to the DAP. With this approach you dont need a password function, but...

The title is not in the form header. I gave the user access to design view, and then he could se the "empy" boxes, no text were in them. I tried to make a few new titles, and those he could see. The user got a new machine a couple of days ago, and i reckon it has something to do with the...

My DB is used by many users. Now, when one of the users enters all titles in a particular form is gone? When I log on, everything works. We use the same frontend file. The other user has used the base for months without any problems, and there has been no changes to the db. The titles are not...

My DB is used by many users. Now, when one of the users enters all titles in a particular form is gone? When I log on, everything works. We use the same frontend file. The titles are not connected to any fields in the DB, it's just a textfield with no functions. The titlebox is present in...