Search results

Just a quick one: I have this now: Code: Text2.SetFocus Dim txtdept As String Dim txtdept2 As String txtdept = Text2.Text txtdept2 = "dept='" & txtdept & "'" dt0 = DTPicker0.Value fromdate = "'CreatedDate > #" & DTPicker0 & "#'" todate = "'CreatedDate < #" & DTPicker1 & "#'" strr = txtdept2...

Hi all, I have this: Text2.SetFocus Dim txtdept As String Dim txtdept2 As String txtdept = Text2.Text txtdept2 = "dept=" + txtdept DoCmd.OpenReport "Copy of inventory transactions - Choose Dept", acViewPreview, , txtdept2 but when I run it a enter parameter box appears asking for a dept...

Hi all, Is there any reason why this doesn't work? Private Sub Report_Load() Dim s As String Dim d As String Dim str As String Dim datestr As String s = InputBox("Enter the dept", "Inventory") d = InputBox("Enter the date from", "Inventory") str = "dept = '" & s & "'" datestr =...

Hi all, I have this: Private Sub Report_Load() Dim s As String Dim str As String s = InputBox("Enter the dept", vbOKCancel) str = "dept = " & s DoCmd.ApplyFilter , str End Sub It asks me twice for a value. All I want to do is enter a dept and then the report show with the filter as for...

Hi all, I am trying to use =sum([price]) in the control source box in my report to add up a list of numbers in the report. the text box that has the amount in is called price. It doesn't seem to be working. I know its a simple fix but how can I do this? thanks Martin :confused:

Hi, I have to create a new table in access which is fine. But i want it linked to the SQL database. My other tables are. When I copy one of the other tables and then paste as a new name it doesn't show on the SQL server. How can I get this to show? Thanks Martin

Hi, I have to create a new table in access which is fine. But i want it linked to the SQL database. My other tables are. When I copy one of the other tables and then paste as a new name it doesn't show on the SQL server. How can I get this to show? Thanks Martin

Hi all, I have a few sub reports on my form, I was wondering if i now place a tab control on the form - can I place these items in to it just by moving them? thanks Martin

Hi all, I have a table with fields like: totalmanaged and ID. Now when the user clicks on the next record I would like a field to calculate the difference between the figure in totalmanaged on the ID before and the value in totalmanaged in the current ID. Is this possible? Thanks Martin

Hi all, I am after some help. I have an access DB but on the start of it I want the users to pick their name from a drop down and then type in their password. when they click on ok it then clicks the details from an AD source and then if ok lets them in. Is this possible? Thanks Martin :confused:

Hi all, I have this code: Dim objConn, objRS, strQ, a, b, stsql, stuser, stpass, stadd, stpost, stfull strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ Server.MapPath("\test\example.mdb") Set objconnection = Server.CreateObject("ADODB.Connection") objconnection.Open...

Hi, Do any of you know if it is possible to do the below? I have an access database that I want to add a box to a box and then the user uses the styles (database will be on a tablet) and scribbles their signature into the box and then when they click 'add' the db takes whats in that box and...

Hi all, I am after the code along the lines of.... If mainpage.item1.text = the same as any record in table [main query] in fields item1 or item2 or item3 or item4. Then - msgbox Is this possible with a line of VBA? Thanks Martin

Hi all, I have upsized my SQL database. Now when I create tables in my database they dont show in the SQL server. How do I make this happen? I am using access 2007 and SQL server 2008. Thanks Martin

Hi all, Is there any reason why this wont work? Dim SQL As String Dim IDhere As String IDhere = idh SQL = "UPDATE Main SET Main.Out = 0 WHERE Main.ID = 'IDhere'" DoCmd.RunSQL SQL DoCmd.Close acForm, "Loggedout" idh is a text box on the form that is linked to the ID field...

Hi all, I was wondering is there a way of deleting rows where there is a duplicate. i.e. 1 a a a 2 a a a 3 b b b 4 b b b I would like it to delete rows 2 and 4 leaving just 1 row in that has the data in. Thanks Martin

All, Is it possible to have a vbs script untick some addins boxes in Excel on start-up? Thanks Martin

Hi all, I have a sheet with quite a few records. In Column A is the title of the person but there are some gaps. i.e. Row 5228 might not have a title in it. when I get to this row can I copy the cells B5228, C5228, D5228, E5228, F5228 and place them in L5227, M5227, N5227, O5227, P5227 ...

Hi all, I am getting the following Technical Information (for support personnel) Error Type: Provider (0x80004005) Unspecified error /add_to_guestbook.asp, line 60 Browser Type: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152...

Hi all, I have the following query named as Qry_Rpt_02. SELECT BaseData.FirstName, BaseData.LastName, BaseData.Title, BaseData.Department, HolidayBookings.Yearfld, Entitlement.Entitlementfld, BaseData.EmpTerm, HolidayBookings.DateBooked, HolidayBookings.HalfDay, IIf([Halfday] Like...