Search results

Have you.... You can set record locks in Tools\Options\Advanced\Default Record Locking and change this to Edited Records.. Should stop users from making changes at same time.... Hope this helps.... Regards, Brian K Leslie

What we did... I work for a retail company, we have 10,000's of photo's and communication problems, nothing worse then running after people for information... We used the code as the naming convention for the photo. Example: Luggage Piece: 9047-0128 Would be stored on z:\Test\Luggage\9047-0128...

Well... I am not sure again exactly what you are looking for.. One of the things I like to do my VBA on when using combo boxes is on change and always restricting users to the list provided through tables or queries.... Which are usually user driven. You could order by Record ID, move last get...

Hmmm... Listen bud, I do not fully understant what your problem is. Here is one solution.. Putting a subform in the footer that has the results. Only other suggestion is to minimize the size of your db, zip it and post it with your reply and i will look at it.... Regards, Brian K Leslie

Alrighty...Well here it is.... Size restriction??? My boss knows about the current 2 gig limitation.. and that access slows down alot... after 1 gig... So where are we at in terms of efficiency... and capacity? Does anyone know. Any replies that are solid and come from reliable sources such as...

Sub "On Entry Of Name" Dim db As Database Dim rsSearch1 As DAO.Recordset Dim vName as String Dim Counter as long Counter = 0 vName = txtName Set rsSearch1 = db.OpenRecordset("tblName", dbOpenDynaset) rsSearch1.Movefirst rsSearch1.FindFirst "[fldName] = '" & vName & "'" Do While...

Hmmm.... :) Well... You could use a timer... You will have to work with sequence of events on your form, or build in functions... I must warn you if you set this up on mouse move as shown above... The application is always changing the color. This could be avoided by setting a condition to true...

This changes the mousepointer to an hourglass DoCmd.Hourglass True DoCmd.Hourglass false returns to normal state SUB lbl.MouseMove lbl.ForeColor = 255 END SUB changes the label color, you would need to test diferent colors and get their numeric value and use it with this code... if...

Well one possible solution may be to reference 2 columns but only display one... Look up values by a query... I suppose these values are stored in a table? If so each person should have a assigned ID? If this is the case you can set-up the combo box as follows: Column Count: 2 Column widths ...

I hope this is not all the problem is... but I think you are trying to concatenate data.... In this case try this, just syntax error.... [Timesheet]=[Forms]![Claim Information_health]![Claims ID] & " - T - " & Date() [Timesheet] format should be general or nothing..... Regards, Brian

Well you can use the DoCmd.RunSql("SQL Code " & txtBox.Value & " SQL Code " & variables & ";" You can reference text boxes or variables declared in your module in VBA hope this gives you some ideas.... Regards, Brian

Use Macro or I suppose you can script it in VBA as well... At any rate show and hide tool bars as you like following events... Macro ShowToolbar : Name HideToolbar : Name VBA code to call it DoCmd.RunMacro ("mcrShowTool") Regards, Brian

Create a link between the 2? Link the sheet into your db and do modifications you want through the db, the balance of your spreadsheet will remain as is.....

Format your data through a query or modify your field in the table, I do assume you are exporting directly from a table... Formatting the field in a query then exprting the query would solve the problem..... Regards, Brian

This approach would work, weather or not it is best or not... Select ("All fields you want on the report... ") WHERE [Reservations ].[Date] Between [StartDate MM-DD-YY] And [EndDate MM-DD-YY] In the report you can order by date and force a page break after section if you want details on...

Sorry try this... I misunderstood... Here I made changes to your db, I added a sub-report and one table to hold current week... Hope this helps, if you have any questions, write me.... Regards, Brian K Leslie

Modified your query.... Here ya go... Try this sql statement..... SELECT PettyCash.[Week No], Calender.[Week Ending], Sum(PettyCash.Debit) as [Total Debit], sum(PettyCash.Credit) as [Total Credit], sum(PettyCash.[Credit]-PettyCash.[Debit]) AS Balance FROM DescriptionOfGoods INNER JOIN...

Yes... It is a percentage such and 0.0725% added the gross salary.... I am to sum all these values... I have tried the CDbl(); CInt(); Rnd(); Fix() Functions..... They are not helping....... And these are report calculations done on the report not values from a table unfortunately... This is...

Easy One I Think!!!! Alright.... I am doing work for my accounting department. They care alot about pennies... :o So here is my delema.... Text Box face values visible to eye: $0.70 $10.55 Actual Values : $0.6962 $10.5456 Text Box Result: (Adds actual values) $11.24 Need the result...

Well here is VBA code to do so... DoCmd.OutputTo acOutputReport, "rptAllDiv2", acFormatTXT, "D:\Temp\rAllDiv2.CSV", False I personnally prefer exporting to 'acFormatSNP', 'rAllDiv2.SNP' files so that the report looks exactly like it does in Access. Otherwise why not excel output, unless this is...