Search results

Hi. I have a query feeding a form. It displays Active Orders. So the SQL is: SELECT Orders.[Order ID], Orders.[Employee ID], Orders.[Customer ID], Orders.[Order Date], Orders.[Shipped Date], [Order Price Totals].[Price Total] AS [Sub Total], Orders.[Shipping Fee], Orders.Taxes, [Sub...

Hi, not been on in a while but an old client has got in touch about something and I am a bit unsure of how big this job could be. Wondering you guys could help advise me better on whats the best way to do it...? The questions The problem I have is the first issue of only showing specific...

Hi, Anyone got any decent templates that they don't mind sharing? For my personal use.. Thanks

Hi, I am attempting to create a mail merge or similar whereby I can take my excel sheet with a list of sales on and create invoices for each sale at the click of a button. In my head I want to export fields such as name, address, product, price etc... from excel to a Word Invoice template so I...

Hi, I built a database for a client in Access and it works fine etc... Now they have come to me telling me they can not get in to go onto their Sharepoint site. Now I don't think anyone technical has tried to do it, rather just the admins in the office. I have never hosted a database on...

Hi, I have someone asking for a relational database but it needs to be build using Excel due to bugets blah de blah. Now as good as I am in Excel, I have never done this before. Always Access. Can anyone help me out where to start with this and are there any templates available that sort of...

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

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...

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...

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...

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...

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...

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

Hi all, I created a database in Access 2010 for a client. Now after completing it they bring up that they would like if possible some security (sure I mentioned it at the start). I know hosting the DB on a SQL server would be best but this is not possible. Is there anything within...

Hi, I am using calculated field as a data type in access 2010. They are working fine. However, I added a new field and now the final calc won't work. I have Subtoal adding loads of fields together. Works fine. Then I have a VATunit field which is a double integer, so enter 20 and my next...

Hi, i have sorted an issue I have to only display an image when a field (paiddate) is not null. I use this code: Private Sub Report_Load() On Error GoTo ErrHandler If IsDate(paiddate) Then Paid.Visible = True Else Paid.Visible = False End If exitErr...

Hi, I have a report that is based on a query. The query has two fields. Start and End Dates. When I run the query the Parameter box asks for the dates by using <[Date1] and >[Date2] What I want is to have 2 fields at the top of the report, that display the values I enter in these boxes...

Hi, I have a check box which on click I want to filter a drop down called METER to only show the records that relate to the field called METERID. So say my METERID is 1, I want my dropdown METER to only show the records that have a METERID of 1 as well. Anyone? Thanks

Hi, I need to show an image called PAID if my hidden field Paid Date has a date in. I thought this would be straight forward but so far nothing. I have my images within the database itself on Access 2010, so I am not referencing any in a C drive or other location. Any ideas? Currently...