Search results

Hi, I have a question, I made a Macros called AutoExec to run "beginning" Function Function beginning() If len(Command)>0 then .................... End if End Function But, it has "compile error: Can't find project or library" Why? What's wrong with it? Thanks.

Hi, how can I change the size of the checkbox, radiobutton? Not zooming, not label, I want to resize the checkbox, radiobutton. Thanks.

Hi, In VB of the Excel, I want to setup like this, if the ActiveWindow cannot show the selected cell at all (maybe show half of it), then ActiveWindow.ScrollColumn = 8 But, I don't know how to check whether or not the selected cell size is shown in the active window. Please let me know, thanks.

Hi, I used ODBC to link the tables from SQL Server to MS Access. When I link the table, it popup the message: Select Unique Record Identifier To ensure the data integrity and to update records, you must choose a field or fields that uniquely each record. Select up to ten fields. It force me...

Hi, I do NOT want to create one field for check mark in the table. I just want to make temporary checkbox to select the record in the continuous form. But, When I put a check mark on one record, the check marks are shown on all records in the continuous form. How can I fix it?

Hi, .Worksheets(1).Cells(10, 1) = 2 .Worksheets(1).Cells(11, 1) = 3 .Worksheets(1).Cells(12, 1) = "=sum(" & .Worksheets(1).Cells(10, 1).Address & ":" & .Worksheets(1).Cells(11, 1).Address & ")" .Worksheets(1).Cells(10, 2) = 1 .Worksheets(1).Cells(11, 2) = 6...

Hi, I created 2 different table Table1: Datatype: Field1: Text Field2: Text Select: Yes/No Table2: Datatype: Field1: Text Field2: Text And then, I create a query to match up the fields of the 2 tables: Field1, Field2. The output results are Field1, Field2, Select values from Table1. But...

Hi, I write VBA in MS Access .Worksheets(3).cells(p,i) = 1 .Worksheets(3).cells(p+1,i) = 2 .Worksheets(3).cells(p+2,i) = 3 .Worksheets(3).cells(p+3,i).formula = "=Sum(" & .Worksheets(3).Cells(p, i) & ":" & .Worksheets(3).Cells(p+2, i) & ")" But, the sum function doesn't work, because it...

So, it will be run slowly, right. Actually, the query2 can retrieve the result from the table directly. But, I created the qry1 to limit the results, and then make qry 2 to retreive the results from qry1. So, it runs 2 queries, it is a bit slowly, right.

Hi, I did 2 ways: If I created a query named qry1, then, I created another query (qry2) which include qry1. Is that meaning running 2 queries? Firstly, run qry1 result, then run qry2. Please let me know, thanks.

Hi, I have an experience for running queries. When I use query to run the linked tables. It is faster. If I use query to run the tables (not linked), it is slowly. I did both ways. Can anybody tell me why running the linked tables by queries is faster than the no linked tables? Thanks.

Nothing. Thanks.

Hi, I create the the combox in the form. The Enter Event of the combox is name.rowsource = "(select 'ALL' From [tbl]) Union (select [Name] from [tbl] Group By [Name] Order By [Name])" The list solutions are: Alan ALL Amy Jeff .... ... Can I put "ALL" in the first postion? ALL Alex Amy ...

Hi I want to change the property setting of DecimalPlaces Firstly, I made the crosstab query, then, I used SQL to create the new table as following code CurrentDb.Execute "SELECT [qry2_crosstab].* INTO [New Table] FROM [qry2_Crosstab];" Afterwards, I used the following codes to change the...

Darn. I mistakenly thought that AccessBoy actually answered [solved] another users request for help. But... same old dribble.

How can I use the HTML format in the body? How can I add hyperlink ? Thanks.

Hi, I have a db1.mdb with user-level security. The Secured.mdw is security file. Everytime we need to refer Secured.mdw to open the db1.mdb. I created another compact.mdb database for compact and repair the db1.mdb at night time. In the compact.mdb: I create the form and setup the timer to...

Hi, How can I enable back the Alt Key? Thanks. Because once the database is opened, I setup For i = 1 To CommandBars.count CommandBars(i).Enabled = False Next i But, the Menu bar has one option, Format I want the user to use "Alt+F" to go the "Format". Does anybody know? Thanks.

Hi, For i = 1 To CommandBars.count CommandBars(i).Enabled = False Next i How can I enable back the Alt Key? Thanks.

Hi, I have a question. In the form, the recordsource is table1. When I use one button to update the values in other records in the same table (same form), there is message Write Conflict This record has been changed by another user since you started editing it. If you save the record, you...