Search results

tblUsers UserID (autonumber - long) PK FirstName (text) LastName (text) tblTracking ReportID (long) UserID (long) tblReports ReportID - (autonumber - long) PK RepName - Text Select tblusers.firstname, tblusers.lastname, tblReports.RepName From (tblTracking left join tblUsers on...

Uhhh... uhhhh.. No can't see it sorry. Can you post up the layout of the main table and say two of the other tables and what exactly you are trying to accomplish? Vince

Stay away from macros if you can help it. Open a recordset using an Sql statement and check for recordsetobject.EOF (End of file) which indicates no records returned if its true when opening. If its false then there is at least one record. So you could then set the sub form/listbox/control as...

Well, depending on the amounts of data you are looking at it may be best to have a search field or two at the top, a list box of results to click on and the form data entry/update at the bottom. The user would then search via account number or name (possibly fuzzy match/wildcard). This produces...

Another way is to use a group selection at the top... By this I mean the option groups, so the user selects which records to look at from here, then you code the save button to check the frame value (access) or the option selected (vb/vba excel etc). Also, if you know what the user wants to...

It looks like your queries do not filter on the first tab of the form, so in theory should show everything. Probably the query on the first form is affecting the sub forms in some manner, and since I don't use sub forms, good luck in finding the correct reult. Post up when you've found it so...

The only combo boxes in queires and tables I ;ve seen is where someone uses the Relationships part of Access. Which I ritually remove ;) heh Anyway, its possible that the relationships need to be looked at. Vince

Using an update query to go from the first to last record... Or if you use code to import, then convert as you grab and put in the table. cdate(right(field,2) & mid(field,5,4) & left(field,4)) Use cdate if you want a date vaule or forget it if you want the string to convert later... Vince

iif(j.duration<1,1,j.duration) Vince

Something like this? Select [table].[item], ([table].[count]/[subqTotalCounts].[TotalCount]) * 100 as Percentage From [table] left join ( Select [table].[Item],sum([table].[count]) as TotalCount from [table] group by [table].[item] ) as subqTotalCounts on [table].[item]=subqTotalCounts.[item]...

Had to run it through two sub queries (including a cartesian :/ ) First one totalled the calls per day (count) Second one put week numbers to the day and calls (cartesian) Third either summed the week numbers and calls or averaged them (avg function?) Vince

dim strSql as string dim rstDocs as recordset '---- set the sql statement and open the recordset '---- (instead of dbengine(0)(0) put currentdb) strsql="Select * from tblDocs" set rstDocs = dbengine(0)(0).openrecordset(strsql) '---- do processing '---- close recordset rstdocs.close '----...

I hope you have a developer/god log in on the mdw. Log in as that. BEFORE doing/experimenting with the below make sure you have backed up the mdw file and your mdb(s) that you will be changing. Nothing worse than losing everything. Tools>security>permissions screen (I think from memory) Select...

Cut n paste the doc into excel. On the spare column on the side write in the numbers 1-7 1 - Name 1 2 - Address 1 3 - Phone 1 4 - Postal Code 1 5 - Comments 1 6 - Separator between records (groups of data) 7 - Blank lines you are not interested in Then you can filter on 7 and erase those rows...

Instr Mid And a creative SQL statement (or two...) Seek? Wassat? ;) Vince

CDbl function around the rstsource("field") eg rstDest("field")=cdbl(nz(rstsource("field"),0) NZ only needed if there is likely to be a null in the field. Possibly you could use an Sql update or insert into linked on a common id. Vince

Do you have a login screen? user preferences/groups? or do you use an mdw workgroup file? Vince

1) Hmm not quite sure what you require here. Possibly an export as a text file which the db holds a reference too - use the date reversed : yyyymmddhhnnss (format function) Alternatively if its only an ID, date/time and a results (byte or bit) even though you have loads of records, it...

Yes you could. Leave the auto number field in as the unique identifier. Make a new field for the response number. Use code or a query to get the max response number so far and add 1 (if null default to 0 using the NZ function). Its an option. Vince

tblFileLocations FLocsID - Auto UserName - Text (or UserID - number if you have a users table) DocPath - text - 255 Sql: strSql = "Select * from tblFileLocations where username='" & environ("username") & "'" Open this as a recordset - read only (static) and populat the list with those...