You are going to need to write a parsing function in vba using the MID and LEN functions. I am assuming that every record will have the dash (-) as the...
Hello, i am using the code to insert values from the temp table to the main table. i only want to transfer all the records where email and userid is not...
Hello everyone, this is a code i created to be able to get the multiple users i have selected in the form. i was able to select the users in the form an select...
Hello, I have two queries: UPDATE EListHierarchy SET EListHierarchy.EListItemUserType = "C" WHERE EListHierarchy.EListItemName in (SELECT EListItemName FROM...
DEARS, I have a table with three field(Item,Size,Colour) There is any remedies to prevent opertore to enter same datas in all three field for eg:-one of my...
Hi all, I have spread sheet like data with 400 rows of data .This has 10 columns . Now this sheet is going to be repeated for 6 stages of work. How should i...
Dear Faisal, In the design view of the table, select the fields that you don't want duplicated and set the primary key (the little golden key on the toolbar)....
Hi, I am not sure I understand the question. However, you can import an Excel spreadsheet using File, Get External data and pick a file type of Excel. The...
the proper syntax is Insert File (Field1,field2,..) VALUES (V1,V2,...) ... have selected in the form. i was able to select the users in the form an select...
you need Where (Userid is not null) and (email is not null) ... main table. i only want to transfer all the records where email and userid is not null.... ... ...
private sub Splitme(Invalue as string, out1 as string, out2 as string, out3 as string) dim iptr1 as integer dim iptr2 as integer iptr1 = instr(1,invalue,"-") ...
Dear All, Read Quran at your Desktop Now read the Quran at your desktop. Arabic version, english version, turn the pages of the quran by hand and read by...
Hello, More questions from this newbie: I have an Application table which has Application ID and Application Name. I have another table Variable which has...
Hello, more help needed: if a have a combobox from a form which displays the ApplicationName using SELECT Variable.VariableID, Variable.ApplicationID,...
Hello, Please help on my query.. compile error expected end of statement error. strSQL = "UPDATE UsersandUserClasses SET UsersandUserClasses.AddUserClassSubmit...
Hi , Can anybody help me...its urgent. I have application (GUI Form) developed in Access'97. Which uses linked database tables. This form is to pass on...
Sometimes when you try to import a database table from another database or export a database table to another database, you may get following two error...
I got a form which is directly connected to a table with couple of combo box . I created a user profile with a list of forms where I defined who can view, add,...
Is Variable a table name? set UC.AddUserClassSubmit = (the select must be in parenthesis) as strText ( is unnecessary) & "'" ) ; " ( at end a mismatch in...
make sure the source for the combo box is either the table or a query that returns Name and ID in the Format tab of the combo box, set it to 2 columns then set...
private sub listbox_click() combobox.rowsource = select fields from table where id = " & List0.Column(0, ListIndex) combobox.requery end sub ... using ... ...
A select returns records, you have nowhere for it to put them. You need to create a recordset and work with it. dim DB as dao.database dim RS as dao.recordset ...
Try going into the Linked table manager and refresh all the tables. Also, where are the linked tables residing? Are they properly indexed? ... linked database...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
