Search results

CurrentDb.QueryDefs("Query1").SQL="SELECT 0;"

Specifications F1 (for XP): Table size 2 gigabyte minus the space needed for the system objects If you need to store 3000 records per day and make a realtime backup you should use SQL server such as MS SQL

..."=Sum(" & .Worksheets(3).Cells(p, i).Address & ":" & .Worksheets(3).Cells(p+2, i).Address & ")"

Rnd F1: To produce random integers in a given range, use this formula: Int((upperbound - lowerbound + 1) * Rnd + lowerbound)

Here you go

It would be better for you to post code of your button here.

Reading inbuild Access Help is very useful. Try start reading from "Creating and Working with Databases". Start learning with books and tutorials on Microsoft Access, VBA (Visual Basic For Applications) and SQL. Look through this tutorial: http://www.fgcu.edu/support/office2000/access/ Read...

Suppose you have form RefRbl and controls ACCT - Number, LastName Make control ACCT AfterUpdate Event with Private Sub ACCT_AfterUpdate() Me.LastName = DLookUp("LastName","PatTbl","ACCT = " & Nz(Me.ACCT,0)) End Sub()

Suppose you have 2 tables: JOBS (job_id, job_name), EMPLOYEES (emp_id, emp_name, emp_hire_date, emp_job1_id, emp_job2_id, emp_job3_id) Suppose also you have an EMPLOYEE single form where you edit current employee To see all employees selected particular job (identified by job_id) is this...

Percent3 is integer ... fix it to Double

Of course you do - FormatPercent returns string.

If you will have compile errors then in VBA editor go Tools -> References and mark "Microsoft DAO ..."

Create a form, place a button on form and then double click it to create OnClick event. Write following code (with your names): Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("YOUR_TABLE") Dim i As Integer i = 1 While Not rs.EOF rs.Edit rs.Fields("START INVOICE NUMBER") = i...

Make this field a combobox with list of values and set LimitToList = Yes in properties

brr.. For i = 1 to 20 If IsNull(Blah) Then Me.Controls("chkQuestion" & i).Visible=False End If Next i

Some ideas only: 1) Try importing tables to new mdb and see what comes with relationships 2) Try right-click on relationships form and select "Show All"

Dragg and drop doesn't work? What does it says?

Do you mean toggle displayed data in form? If it is yes, then place checkbox YourCheckBox1 to form and use this code in OnClick event: Private Sub YourCheckBox1_Click() Me.Filter = "your_yesno_field = " & Me.YourCheckBox1 If Not Me.FilterOn Then Me.FilterOn = True End Sub

Describe exactly how you want to append records to RefTbl. What fields or what calculations based on PatTbl should be insertet to RefTbl? If your manipulations with PatTbl can be presented as a select query then you can create that query and then qreate insert query in Access designer (read...

...WHERE your_date < CDate("2006-01-31")