Search results

To everyone that provided answers, THANK YOU. The Seq and ClassCode fields aren't needed in my opinion. It was something that was transferred over from the paper format. I was asked to automate the process using Access. So if a code can be written using the InventoryNum and Prefix1 fields...

Hello, I would like to Access to generate a sequential number based on a current table and fields on a form. I’ve been thinking about it for days and I’m stuck. Any and all help is appreciated. The table contains the following fields: Inventory Number, Prefix1, Seq and ClassCode. InventoryNum...

Hello, I have a form that has a hyperlink on it that opens that specific file. I'm trying to create a button that will allow me to email that specific file to someone. This is the code I've been playing around with for a few days but I can't get it to work right: Private Sub...

JHB, thanks for the tip. I changed: "=Between #" to ">=#" and "=#" to " <= #" And date range now works. Much appreciated!

Hi! I came across this code from Martin Greene but need a little assistance on it. http://www.fontstuff.com/images/acctut17n.gif http://www.fontstuff.com/access/acctut17a.htm#download I'm trying to create one query from a form that will help users that don't know exactly what they're looking...

I'm not sure if this is possible or not but I figured I'd ask. I have a form that has a hyperlink on it. When I click on the hyperlink it opens up that specific PDF. I have a lower level supervisor who always comes up with "great ideas" and asked if there's a way we can preview the PDF before...

TJPoorman, after playing around with the code I figured out what I needed to do. Thanks for your help. Here's the code: Private Sub FileName_AfterUpdate() Dim strTemp As String If Nz(Me.FileName, "") = "" Then Exit Sub If Me.DCRCR = "DCR" Then strTemp = Me.FileName...

Thank you for your reply. I seem to be getting an error message of it can't follow the link. When I look at the link, it is: NC ABC 02-22-2013.pdf#http://NC ABC 02-22-2013#S:\Support Services\DCR\NC ABC 02-22-2013.pdf#http://NC ABC 02-22-2013.pdf# The code works without the first...

My office runs data requests. In order to track it we are entering it into Access. Which company requested it, date of request, date sent to IT, date sent to requestor, data type and file name. The file name is the document name. Document name is the request we receive from the requestor and the...

I'm trying to help my department with a form. I have a field that we enter the document name. I would like to make this a hyperlink to the document. I would like the code look at another field. Depending on what is entered in that field, it will let you know what folder name we are going to be...

RossWindows, I had a few days to look it over and I think I understand what you did. I've figured out how incorporate your sample into my database. Only question I have, and I have a feeling it's going to be something simple, but how did you get the form to keep the focus? Meaning I put it into...

RossWindows, this isn't really what I was thinking of but it looks great! I need a day or so to look it over before I start asking question. But I'm definitely going to try to make it fit into my database. Your help is REALLY appreciated.

Thanks for your help but I'm not sure I understand your reply. Why would I need a field named DateIn? In my mind DateOut and ExpectedBack should be able to cover it. No? But everything else you have posted is pretty much how I have it set up with the exception of ParkingPass. I have it as a text...

I need help for a project at work. I'm tired of doing it manually and can't take my co-workers acting as if the world was going to end because I wasn't in to get them a card. I now have some help. A co-worker will be helping me with this but I need some help getting it started. I created a...

Hey guys, thanks for all your help/suggestions. I've never used recordsets or dlookup. Perhaps you can help me further with this. This is the expression I used in the query to identify clashes: NoClash: ([tSchedule_1].[StartDate]>=[tSchedule].[EndDate]) Or...

Yes, I created the query and it gives me the overlapping entries - that's not a problem. But how do I put it into the form? If I make this query the record source, all I get are the overlapping entries from the Schedule table. I'm looking to make the form reject overlapping events.

HiTechCoah, Thanks for some direction on these issues. But how do I incorporate it into the form so duplicates and overlaps are rejected?

I’m new to Access and this forum. I just started using Access about a year ago and really enjoy working in it. But I’m not whiz kid at it and any help is much appreciated. My friend took over my old job and asked me to help him with room scheduling. Previously they were using Excel for room...