Search results

Hi I have a report which is populated from several queries. The report is constructed off a main report with 3 subreports inside it. The problem is that in some cases one of the subreports is empty...and when i print, it prints out blank pages. Is there a way i can prevent access from printing...

Hi I am using a textbox to read in passwords. I have masked the password, but i want to limit the chars to 6. Can anyone tell me how to do this. thx Anauz

Hi I have a query where the user needs to enter their thier userid. I was wondering if we could use getuserid() in the where filed of a query. I tried this but nothing happens. the query just won't run....no error messages or anything. Can anyone help? Anauz

Hi I have a report which i want to email to people, i have set up a command button that does this. The problem is that when i export the report some words are incomplete and some words do no appear at all. Can anyone help thanx in advance

Hi All Desperately need some help. I have two tables Company(t1), Fleet(t2) Each company can have n aircrafts. What i want to do is count and total the different types of aircraft each Company has.....can anyone help? Thanx in advance

hi I have some data in a multiuser db that i want to create a graph from. What i am doiing is exporting the data in excel with some code, and manually creating the graph in excel. What i want to do is write some code in access that will create the grah automatically. I thought about creatin a...

Hi I have a form which works out curreny exchanges between $US and £UK. I have a field which takes the exchange rate. The problem is when i type in a decimal such as 1.79 it rounds up to 2. It there a way i can stop it from rounding up? Thanx in advance

Hi I am passing some data from Access to excel, so i can create a graph. I have a macro in excel where it creates the graph automatically. What i want to do is take the macro from excel and place it as code behind the button whic exports the data to Excel. Is it possible to perform functions in...

Hello I am writing a list to a text field in my form. What i want it to do is write each member in the list to a new line. What it does at the moment is write them all on a single line. Any ideas? Thanx in advance.

I am running some VBA code which looks at a secutiry group to determine which user belong to which group. At the moment the results are displayed in the debug window. What i want it to do is display this in a memobox od textbox. The groups are not in a table but in Access's workgroup file. Can...

Is there a way i can group fields together and lock them via the grouping option rather that locke them individullay. I have over 60 fields and need to lock/unlock depending on the action being performed ie add/edit I can open the form in red only mode using code - DoCmd.OpenForm stDocName, ...

Hi All I am creating a security form for my db. What i want to know is can you take the value out of a txtbox, and place it in the "where" statement of embedded sql? Before anyone asks why don't i use access's security wizard.....i have and it works fine. The problem is that the db is going to...

Hi I have some buttons on a form which i want to move to differnet positions depending on who is logged on. ie some buttons will be hidden....some not. so i want to fill in the gaps of hidden butons. Any help will be appreciated Thanx in advance

I have a form which loads/saves data to 3 differnet tables via tab forms. I have a button which deletes the selected record from these tables. The problem is that when i click on the delete button, it only deletes the record from the tab that has the focus....where i want to delete fromall the...

I have a form which saves/loads data from 3/4 differnet tables....via tabs. However I do not want to save some fields...is this possible? Thanx in advance

Does anyone know of a function that will say count to 10 seconds before performing a command

Does anyone know if it is possible to have multiple line msgbox's? ie line one line two line three thanx in advance

Hi I have a combo box which i use to populate other fields in a form. When the form initially loads the CBX is defaulted to blank...and as a result the rest of the form is blank. What i want to do is when the form loads populate the cbx with the first value in the query it runs from. Any...

Hi I have coded a query in a button, but i can only see the results in the debug window. Is there a way i can insert the results into a table or a query? Thanx in advance

I want to be able to display first record in my table in the combobox rather than a blank field. I don't want to put in a default value in the properites box because it is sorted Alphabetically....and something could replace it as the first later on. Any ideas? Thanx in advance