Search results

Hi, Would someone be willing to create an excel file that will scrape all the course and details from a Universitys website? Trying to use YouTube but just do not get it at all. Thanks

It is single desktop database. The password is required in case anyone jumps on the PC at tries to access it. Also would the above option work in 2010? Can I assign permissions?

Sounds like your database is not normalised. If I read you right the main form is going to hold animal details. Then your subform you are going to assign parents (as in mother and father) to each animal. But these parents can also be found in the main form? If so, would a drop down menu not...

Hi, I have a form called MAIN. This form contains 3 tabs. Tab 1, Tab 2 and Tab 3. On tab 2 (SUB1) and 3 (SUB2) I have subforms. On the MAIN form I have code to prompt the user for a password when I try to open the MAIN form. Works fine. I have code on the Tab Ctrl to prompt for password...

Last issue. The above is sorted but I have something else... When client opens the main form they are prompted for a password using this code in the Main Form code: Private Sub Form_Load() Dim pwd As String pwd = InputBox("Authorized Users Only. Please enter password.") If pwd = "mypass" Then...

Still getting the error mate. When I debug it says the error is in this sections of other code: Private Sub TabCtl9_Change() Dim strInput As String Dim ctl As Control ' Hide controls on tab until correct password is entered For Each ctl In Controls If ctl.Tag = "*"...

Hi, I have this working but I have a problem. I have form with 3 tabs and I need password on 2 of them which the code above works. However I need to hide the fields when prompting for password. I entered the code from databasedev tutorial along with this from there also: Private Sub...

Works perfect. Out of interest (and if client requests it), how would I code it if I needed to enter different passwords for each tab?

Also my tab control is TabCtl9 but the 2 tabs I need passwords is ContractsTb and InvoicesTb. Currently only asks for password when I click on the ContractsTb.

Hi, I have this code that works. I have a form with 3 tabs. When I select the middle tab I am prompted for password but if I click the 3rd tab I am not. How do I fix this? Code is: Private Sub TabCtl9_Change() Dim strInput As String Dim ctl As Control ' Hide controls on tab...

Thanks will give it a go. The are 2 subforms on 2 tabs on a main form. I just need ComboBox on Subform2 to only show records that relate to the ID of the record on Subform 1. Thanks

Hi, I have a combox field on subform C that shows records from a query. How do I get this combo to only show records that relate to an ID on subform B. I have a subform for storing contracts and these are stored against a company name. On subform C I have a field that currently shows all...

Hi, I have a list box that displays records. When i double click a record it opens the form needed. However I want it to open the form but default to a specific tab. But when it goes to the tab, the subform within it needs to match the ContractID of the record they double clicked on in the...

Thanks guys. Split it is!

Also would this problem be sorted if I split the database? I am using Access 2010.

Hi, I have a Northwind template on a shared drive. 2 people can access it at the same time and when I tested it, both could access the same record and edit that record on 2 different PC's. But now my client saying records are only being added on 1 PC and not the other when they're entering it...

If my row source of listbox reads: SELECT QRY_SearchAll11.priceCostID, QRY_SearchAll11.Client AS [Client Name], QRY_SearchAll11.contract_ManualID AS [Contract ID], QRY_SearchAll11.MeterRef AS [MPAN/MPRN], QRY_SearchAll11.Current_All_Units AS [AU ppkWh], QRY_SearchAll11.Current_Day_Units AS [DU...

Hi, I have a list box that is fed by a query. I have fields that are stored in the table as numbers (Type is Double and Standard Number with 3 decimal places). In the tables I see the numbers 10.000 which is correct, in the query is see 10.000 again correct, however the list box on the form...

Thanks. So my report runs off a query. Would you advise your one above or other solution? This is just for 1 report in an Access database. In my query would I just add a new column with that criteria in?

Hi, I have a report based on a query. What I want to happen is any fields that return a 0 or £0.00 value, to show as a blank cell rather than the populated 0 version. Is this possible? Thanks