Search results

I have a db on a network that is being access using a runtime version of access. FE local and BE on the network. I have user level security setup and everything works fine as long as an aministrator of the pc is logged onto the pc. When someone else logs on to the pc and is not an aministrator...

Thanks for your reply. One thing that I failed to mention, is that I am using the same concatentation on other reports in the .mde and they are working OK. I even think the end user told me the report was working fine and now all of sudden the error message appears. ???

I have a database that I converted to an .mde and I then distributed it using the 2003 Developers Extension Tools Packaging Wizard. So it is being accessed using a runtime version of Access 2003. On one of the reports, I am concatenating two fields, [LastName] and [FirstName], from the...

I rebooted my pc 3 times. It seems to be working now, but for about two hours it wouldn't function at all. I don't if it was something hung up on my pc, server or what.

I cannot open or view the design of any report. I have opened several dbs and all of the reports are behaving the same way, I can't do anything to a report in any of them! Earlier in the day everything worked fine and now all of the sudden it does not. Can anyone help???

I have found that you must have MS Word loaded in order to view pictures.

Create a field in your querie with a nested IIF statement. Example: Category:IIF([StartDate]-[Testdate] between 1 and 29,1,IIF([StartDate]-[TestDate] between 30 and 59,2,IIF([StartDate]-[Testdate] between 60 and 89,3,IIF([StartDate]-[Testdate]=90,4,IIF([StartDate]-[TestDate] Is Null,4)))))

Wouldn't it be easier to change the focus to the next field using the AfterUpdate event? me![FieldName].setfocus

I use A97 and also have the A97 developer's edition. I have a db I need to distribute that uses a bar code font. Is it possible to distribute the bar code font using the developers edition? Thanks.

What email software do you use? Outlook, Lnotes?

Does anyone know why I am getting the message "Microsoft Access cannot create window" when I open my db using a desktop shortcut? Once the message comes up, I can then open without any problems?

I have used it but it not exactly what I am looking for. The environment my system is working in is pretty noisy and that tone seems a little muffled. Thanks for your post!

I have searched for this answer but have not found a simple solution to this and there may not be one. Is the a way to play a wav file or any other sound file in an after update event to serve as a confirmation tone to a particular action ( ie: bar code scan confirmation tone) ?

I have a fairly simple report that links an MSWord file that contains a few graphic images. These images will not print if I have my printer set to "draft" quality, thet will only print when the printer is set to "normal" quality. When I print this file (template) directly from Word it prints...

Lnotes email You can use Access to send an email trough LNotes. Here is some code I picked up from this forum. Dim s As Object Dim db As Object Dim doc As Object Dim rtItem As Object Dim Server As String, Database As String Dim strError As String Set s = CreateObject("Notes.notesSession")...

Thanks, I'll give it a try.

Thanks for your post, I have searched and not found the answer I am looking for. I am not necessarily looking for someone's age as much as I am filtering someone's birtdate to see if they have one coming up.

I have a simple db in which I am compiling profile information about customer contacts. General stuff like name, address, etc. and Birthday. I want to write a query that will show me anyone who has a birthday in the next 30 days. The info in the table is date/time and is formatted as short...

Try this website http://www.gracemere.com/AccessMaintainer/, I have used this on several occasions and it always seems to fix my problem.

when trying to open a database to make a change to a form I encountered an error message I not yet seen: " isn't an index in this table. Look in the indexes collection of the TableDef object to determine the valid index names. Can anyone give me some insite as to how to fix this problem?