Search results

Hello, I have a sub form which contains test results: Test Date, Test Result, Module, etc ect. on the main form I have a Radio frame with 3 options: "All tests, Passed, Failed" I want to filter sub form based on the option selected. all tests will show all, passed will show those with a...

Sorry where would i put that? Regards,

I have a field called "test scores" which is currently set as Text with entries like "89%" How would I go about changing these to just the number so I can create field to manipulate the data? I tried changing from text to number but it changed them all to 1. There are several thousand...

Hello, I choose disable full menu items on a database. How can I reverse this? :eek: Regards,

Thank you!!!!

I did some research on google and apparently the "On Change" event does not fire while the contents of a text box is being changed but when the users commits the changes. Scenario: I have a list box that contains all the courses we offer (a lot!). I have a text box under this not bound to...

Hello, I would like to know if there is anyway to apply formatting to a text box. The scenario, I have a form which employees enter information into (amazing, I know!) The thing is, they really like using the CAPS LOCK when inputting. Which is really annoying and also makes reports and mail...

I set up the short cuts myself, but I dunno, I could have. The database was on her computer before being moved over to the network... which doesn't sound good!! I'm sure I checked though.... oh dear I really hope it isn't this I will look like a fool!!! I'll be sure to double check though and...

So you don't think it's the code? I just wanted to be sure because, if I split the database into front/back end, which is fine I can do that, I dont want to put them to work to find one persons records go missing again. The are both female and much older than me.... I'll be mince meat...

Worked a charm, thank you very very much!!

I could split the databases. Hmm I have been pounding the post about the code. Here is my form, you can see the radio options: I used this code to convert this into a text for the fields within the database: Private Sub FrameQ5_AfterUpdate() curvalue = FrameQ5.Value Call...

Many thanks, I am trying this at the moment, I'll update you on the results :)

Would you mind if I sent you the code, there isn't a great deal.

Hello, I wonder if there is anyway to do the following. The company where I work has a database of client details. The table for storing these include fields which relate to the personal details of the client (name, dob, address, contact info, funding stream claimed etc) The table also...

Hello, I recently designed a database for work. The database consisted of tables, forms, reports, queries, etc etc The database was for collating feedback form responses. There where seven different feedback forms for different programmes we offer. Each feedback form had its own table, forum...

Hello, I have created a database for my company. I want to limit the permissions end users will have. I want to lock all design to the database (similuar to make ACCDE) however I want to re-enable design permissions to administrators, this would be done via a button on the form prompting a...

It's far easier to get pirated games now then buy them. Why *PAY* for *DRM*-ridden games when you can quite easily download them (often faster than the time it takes to go to the shop and buy it (but that depends on your down-speed and the quality of your site/app). I could tell you that I could...

It's because all the information had to be extracted from excel worksheets. I like the idea of name, dob and ni on one table, however, would there be a way to extract this information with out having to re-input all the data again. What I mean is, how would I go about giving all the records a...

Hi there, I have a access database with several tables each with almost the same fields. For example: Name, date of birth, NI Number, provision etc I want to make a report (or query) that searches each table and displays any fields it finds based on a user input NI Number. So I want this...