Recent content by ACMAIN_CHM

you can use the DCOUNT() select [Name],[Date],[Hours],dcount('[Name]','yourTable','[Name]="'&[Name]&'" and ([Date]+1=#'&[Date]&'# OR [Date]-1=#'&[Date]&'#)')+1 newField from yourTable or you can standard SQL as select a.[Name],a.[Date],a.[Hours],count(b.[Name])+1 as newField from...

for example, the tableA with column colC as below colC ------- aabcdf vbd v df then you can use the TRIM() to remove the both prefix- and -suffix space. update tableA set colC=trim(colC) best regards acmain

when we set the form.AllowAdditions attribute, the form will not allow any new records insert from the FORM.

maybe you can put the code into the button click event. currentproject.connection.execute "insert into table2(column1) values " & text1.value & "+" & text2.value

try this Private Sub Command45_Click() tot_valtxt.Value = val(currency_ratetxt.Value) * val(Listbox12.Value) End Sub

yes, we can add more criteria in the Dxxx() function same as we used in the select where clause. Me.ScansOK = DCount("[Err_OK]", "TblLog", "[Err_OK] = 'OK' and Station='" & me.StationID.Value & "'") Me.ScansERR = DCount("[Err_OK]", "TblLog", "[Err_OK] = 'ERR' and Station='" &...

one simply solution like below, you can also use the ucase(col) if not case sensitive. create table t ( col1 varchar(30),col2 varchar(20)) select col1,col2, iif(instr(col1,'A')>0,10)+iif(instr(col2,'A')>0,1) as flgA, iif(instr(col1,'B')>0,10)+iif(instr(col2,'B')>0,1) as flgA...

maybe you can try this SQL as below SELECT tblAnsweredQ.Score Sum(tblAnsweredQ.Score) AS Tot Format(DSum("Score","tblAnsweredQ" =" & [txtTotal] & "") AS RunTot FROM tblAnsweredQ

you can refer to the user-level security concept in the ACCESS. by this way, the normal user (user id ADMIN) should not be grant the "Modify Design" permission for <New Reports> in the menu -> Tools -> Security -> User and Group Permissions for detail information, you can get from the...

hi Xion.Hack, how about your Table structure ? we did not know wether there is already a auto-increment fields or other PK in your Table. usually you can add a column with AutoNumber datatype and it will start from 1. if you want to begin with 21, you need create a another table with same...

same experinece like me. the default account Admin belongs to 2 groups, Users & Admins. so if you want to revoke the permission for user account Admin, you need remove the permisson for groups Users & Admins as well. CAUTION, before you revoke all the permission from admin, admins, users...

hi tim419762 , as there is no ROW_NUM like other database system e.g. Oracle, so you can not directly get the ROW_NUM in ACCESS, but you can count how may records which before your current records if you have the order by fields. select count(*) as rownum, a.id,a.fd01,a.fd02 from yourTable...

hi Jerry, I am also wondered where is the [tblUpdater] come from , is it a FROM or another table/query? UPDATE tblContributors INNER JOIN tblContributions ON a.ContributorID = b.ContibutorID SET b.Category = [tblUpdater]![Category], b.Description = [tblUpdater]![Description] WHERE...

if you want to alter the table structure, you must lock the table while there is no other user is accessing it. so the job has to be done at either mid-night or weekend. but you also can schedule a job which execute a script to alter the table structure. for example, you can schedule a VBA...

solution 1. you can use the TOOL->Analyze->Documenter to get the DB structure in word, and then compare these two doc contents. solution 2. you can use the VBA to get all table structure. here is an example to get the table definition. Public Sub getTables() Dim rs As New...