Search results

If you don't want to get involved in Db security then you can make separate interfaces for each department. Create a separate backend and only link the tables appropriate for each of your front end interfaces. This will mean that different departments will need to have their own tables (except...

First of all the report name: Before you run your save command, create the name of the report and assign it to a variable. Then the variable is used as the object name in your save command. To create the name based on last day in week, you could use something like the dhLastDayInWeek...

Could you not simply set the focus to another control immediately following the enabling of the scrollbars?

You could try something along these lines: Dim intReports As Integer, rpt As Report Dim ReportName As String intReports = Reports.Count If intReports = 0 Then Exit Sub Else: For Each rpt In Reports ReportName = rpt.Name If ReportName = "Your Report Name" Then MsgBox...

Hi, I have a report in which I had to display so many fields that it spans the limit of 55cm. I have formatted it carefully so that the first half of the fields appear on one page and the second half on the second page. This all looks fine. My only problem is that my report header also spans...

I have generated an UPDATE statement but keep getting the error message that it was expecting a reserved word. Naturally the statement begins with UPDATE so I can't figure out where the problem is. could someone please take a look and help? UPDATE tblComparativeVolume RIGHT JOIN tblVolumeData...

Thanks Carol for the response. This problem is going to be a little more complex however. Further research is indicating to me that I can't simply use a straight query with parameters that come out of a custom dialog box. What I will have is a the same set of data being pulled out for each...

I have a table of volumes processed for a particular financial quarter including the totals for each month within that quarter. I need to create a series of static information reports from this data. The table is broken down into clients, products and activities with their respective volumes...

Hi everyone, Thankyou all for your input. This problem had me really stumped, however I have managed to solve it. Everything seemed to check out, the same number of rows was appending, there was no rounding, there were no null values that were being omitted, and when I did a straight copy...

Hi, I'm using the docmd.transfertext action to import a .csv file. The file is a softcopy of an invoice. I have the spec set up and I thought everything worked fine. Now I have found that when I import the file using the code it is somehow changing my values in the (monetary) amount field...

Thanks Jack! That works terrific now.

I'm doing a custom function to get the last workday in the month. This will be used in an update query on (obviously) the date field. The function first gets the last day of the month. I then test that day with 2 additional functions to see if that day is a Saturday or Sunday. If Saturday...

Thanks for the suggestions. On the report that I'm referring to above this works fine. I actually put those details in under the Vba section where we were also debating this one. However I'm trying to do it in another report within the same database and this one won't work. Again it should...

I finally got this to work! Yes it must be in the OnFormat event rather than OnOpen. Also I changed the default property on the ole to be non visible. Then because I couldn't get it to work by checking whether the 4 fields were null, I had it check for the 2 fields that total these 4, but...

This is a similar problem to RpbertS's listed a little while ago but unfortunately not yet answered. I have a report with 2 fields that are bound ole objects (scanned signatures). The second signature needs to be printed only if the report contains letters that are barcoded. So I'm trying to...

I have what should be a simple task. I have a command button on one form that opens another form with an SQL string as the linking criteria. Depending on which record I am in, there may or may not be details to show in the second form. At the moment because the second form needs to be read...

Firstly, is there a standard/built in function called Parse()? I'm making addtions to someone else's database and they use this in a piece of code. I can't find any information on this in the Help files and the MSDN Search was typically lacking. I tried tracing it back in the database as well...

Sorry to be a pain!! Thanks again for the suggestions. By changing the recordset to Snapshot though the information in the form can't be updated by the requeries as I scroll through the records. And I tried opening the form with code as acReadOnly but that doesn't seem to make a difference...

Thanks for the suggestion. Unfortunatley, although the requery is only based on 2-3 combos, there are around an additional 40 or so text fields or other combos on the form. I would rather not have to select each individually and set Enabled to No and Locked to Yes. Is there something I can...

I'm trying to make my form completely read-only by changing all the form properties (Allow Filters, Edits, Deletions, Additions, and Data Entry) to No. This worked up until the point where I placed an On Current Event procedure that requeried a couple of Combo Boxes to show the applicable data...