Search results

thanks for that :)

Ok.. How do you do that?

I'm trying to disable the ablity for people to access the backend of my database from the frontend..

Hi, I was wondering, is it possible to disable the ability to hold shift when opening a .mde file?

Bound form with a SQL update. the sql update gets called in the BeforeUpdate am i doing it wrong?

Hi, I keep getting a write conflict message when i try and modify a record.. can someone explain to me why this occurs

nope there is nothing like that. that was the first thing i checked

I have a continuous form that has three text fields, one plain text (description), one date (date), and one another plain text (name). There is also a delete button.. When I click on the date text box, a calendar is opened, date selected and that is then inserted into the date text field. The...

Cool thanks for that.. it was requery that did it..

Hey, I have a subform that displays a list of records and i'm trying to figure out how to delete one.. I've setup a delete button that deletes the record from the table, but that doesn't delete the record being shown in the subform, but simply replaces the values with #Deleted Cheers for...

can you attach your db so i can take a look

Hi, just wondering if its possible to consolidate records in access. I have a bunch of information imported from a spreadsheet in the form UserID Time -------------------- 1 4 1 4 1 10 2 2 2 5 3 4 3...

cool, thanks for that.

im not sure, i think i've confused myself here. it may be very simple. i'll try and explain it clearly and you can tell me what you think. Importing a bunch of spreadsheets. From the data, I have a couple of fields with numbers, these are then sumed, based on that number, a risk rating is...

mmm, the problem is that the reports i want to generate would be along the lines of all records with a High Risk, which means that I would have to build a query that first goes through all the records and calculates the Risk, and then pick out the ones with High Risk

im not confusing the two, i just wasnt sure on how to use the value calculated on the form in a report. ill try the query method thanks

you want your combo box bound to the facility table, but only the name and ID, have ID in column 1 and the name in column 2. have the combo box bound to column 1, and then have the column widths as 0cm;2cm That should give you a combo box that only displays the facility name, but returns the...

build an sql update query that makes the changes WHERE CheckNum = fld_checkNum

Ok, i'm currently building a database, with data coming from a series of spreasheets. From those spreadsheets, a number of values are read, and from them a risk rating is determined (low, medium, high) This value is not from the spreadsheets, and is determined when a particular record is...

correct. The users can launch the database fine, except in the case where somebody else already has it open.