Search results

I think what I am trying to do is probably more described in "C". The data itself is really being updated in the main source db. I am trying to get the date a table was created as this specific db is more of a read only concept vs. data input. I just want the created date to be visible and say...

I've got a secondary database that will be used in a portable device which will get its data from another db prior to being placed onto the portable device. What I would like to do is put a text box on the opening form of this database showing the date the table was built. To update the...

Isskint, Thank you very much for your assistance thus far, This is really a great start to what I was looking for. Objectivly I am looking for any pictures more than 600X900 pixels, in looking at the kb size of pictures such as this there is a variation in "kb" size as color quality and so on...

Can you give me an example for this process, its not working as planned. Thanks for the help. Respectfully,

Please forgive me for asking and the continued questions. What is QBE and how do I apply this. Can you show me an example? Respectfully,

I have a database which contains a field with a .jpg attachment. I am in the process of decreasing the size of each attachment to reduce redundancy and increase consistency. I have roughly about 600 photographs I am currently working with and due to the nature of the database, additional...

That is correct, I ran each letter designator up to 1500 so I didnt have to keep creating and replacing the table over time as the numbers got higher, hoping to do an automated thing on this; however if i have to create a new table every time I want to check for missing case numbers, I can do...

In reference to format, everything is correct with an exception of the letters; those true letters will be BS, LS, and BP. I created an excel sheet and built a list for each designator starting with ??#13-0001 up to ??#13-1500 and imported it to a table. I then created a unmatched query to...

This is the one i'd like to use so i'm not getting a long list of cases that havent been issued yet. I'm having issues understanding as to how I implement this code into my dataase. Is this the sql for a query or is it three separate steps that I need to take to set it up? Thanks in advance...

I forgot to mention something. Our facility has three different sites therefore the last four digits could potentially be used three separate times. For example: AB#13-1234, CD#13-1234, EF#13-1234, the two letters at the beginning of each case numbers are indcators of the site the case number...

I am trying to create a query to find missing sequential numbers in a text field. I am using this specific field as a case number which is designated as two letters, the # sign, two digits indicating the year, a dash, and then a four digit number; For Example: AB#13-1234. The reason for this...

I have a form that is being opened by a button with a vba command as followed. Private Sub Command33_Click() DoCmd.OpenForm "caseedit", , , , acFormReadOnly End Sub One of the fields in the form is a combo box that the user can choose an associated number to each field and open the data...

I finally got around to looking at this in depth; however unfortunately its not working. It is in fact pending the id numbers but the pictures are not moving into the image field. This probably has a lot of relevance; but the pictures are of .jpg format.

I just ran across this post as I was searching the same question. I was wondering if after 7 years you came up with a resolution?

This is exactly what I am working on right now. I found the query mentioned by Bob in a forum but that is all there was. I like the table concept, is this a combination of both; if so I have the same question, how do you link the reports to the table?

I was thinking of somehow using the "Caption" of the report for the "user friendly part of this step. I found the above mentioned code in a post dated from several years ago so this process i'm trying to take may not be the way to go. In the gist of it, regardless of how do it, i just need...

I've searched this only to find responses dated more than about 4 years ago and not exactly working for my issue, so hopefully someone here can help me out. I have a form with a combo box listing all my report names who's name is reportlist the row source for this combo box is as followed...

I think I just figured it out. If DCount("*", "tblcases", "[subjectname]=" & Me!SubjectName & _ " And [casenumber]=" & Chr(34) & Me!CaseNumber & Chr(34) & "?") > 0 Then MsgBox "case already exists." Cancel = True End If In comparison, I removed the # sign at the end of the code, where I...

Ok, i've tried this a few different ways and its not working. It may because I am trying to combine different types of data in the dlookup but here is what I have. Table includes multiple fields with the two specifics I dont want duplicated. Subject Name and Case Number. In the table...

Bob, I know this post is old and solved on the initial problem; however I've seem to come to an issue hopefully to be an easy fix. I'm trying to use the same "dlookup" code in a table that has the primary key from a related table rather than the actual verbiage. Is there something I need...