Search results

Thanks for the reply Fizzio This is the code that I have used for the form, it was working before but since I have added (frmLicencesProcured) to the end of Call Audit_Trail it is giving me the error Ambiguous name detected. Have I done what you asked me to do Fizzio??? Private Sub...

I have this code in a module for an audit trail, it is working fine for controls on my main forms but I cant get it to work for subforms on my main forms. I have added the code to the subforms exactly the same way as I have to the main forms. If you open the sub form it works fine but when you...

first i would look at my attachment to see my table structure and relationships. there are 20 questions in tblQuestion, i want the user to open a form, enter the caseno, click a button and a subform (control source = tblMain) will poulate with the 20 questions. then my users can add their...

hopefully this time

attachment didnt seem to attach with first post

Does anyone have or know of a questionnaire database example??? I have been playing about with my own effort but so far I cant seem to get the questionnaire form working without alot of end user work. I have tables set up in a way which i think is correct as it will allow me to query the...

that didnt work for me, this is what is used INSERT INTO tblMain ( QuestionID ) SELECT tblQuestions.QuestionID FROM tblQuestions; I created a button on my form to run this query but when I run it i get a message box saying that I cant append all the records due to type conversion failure I'll...

Really stuck here, I am trying to set up a questionnaire form, I have a form with case no and then a subform on this form to display the questions and answers, after taking advise from a post on the forum I split my tables up, one for questions and one for questions and answer. This is working...

i am going to have a questionnaire with possibly 90 or so questions on it, 90% of which will be yes/no answers. the users want a report to be produced to highlight the no answers only, i have been playing about with a small prototype with only 15 questions but i am struggling with ideas on how...

I am looking to use the DoCmd.TransferSpreadsheet function. I can get it to work but i have just a query regarding this. Is it possible to import records from a spreadsheet that have blank fields? When I was testing out my code I could import 90 records instead of 130, the 40 that didnt import...

I have an access table that is backing up a web page. One of the fields that is contained in the table is rlo_number, which is 2 digits. What i want to do is to be able to format this so that field in the database reads rlo.[rlo_number].html, so if the user types in 55 in the web page then the...

I have an access table that is backing up a web page. One of the fields that is contained in the table is rlo_number, which is 2 digits. What i want to do is to be able to format this so that field in the database reads rlo.[rlo_number].html, so if the user types in 55 in the web page then the...

Hello there, Just looking for some advise. I have a master database that is based in the office and stored on the server. However the nature of our work takes us out of the office to visit clients at remote sites. During these visits answers will be recorded to a number of questions, usually in...

They are currencies with the decimal places set to 2

I have a query that is retrieving figures from a table for two column headings. The query is then used as the record source for a report. On the report I have used 2 text boxes to sum the lists of figures. It works out 2 totals but they are incorrect. When I use the sum function in the query it...

I have 2 user privilage groups, administrator and user. I have created 2 custom menus, one with all forms, reports etc for the administrator and one with limited forms, reports etc for the user. I there any way that when they log in that the relevant custom menu is displayed according to their...

I followed a post on this forum on how to disable certain menu items in a custom built menu but i was wondering if anyone knew how to disable actual options within these menu items, for example if the the menu item File contained the options Open, Close, Print and Exit, how would I go about...