Search results

Yes to my knowledge myself nor any other user was in the database. If there was one, I get a warning saying its read mode only.

Each record contains an autonumber, 5 number fields, a date/Time field, and 4 text fields. I wouldn't think this would be too demanding seeing how I have another table with an autonumber, 6 number fields, 6 date/time fields, 7 text fields, and 30 Yes/No fields. my understanding, Access uses...

I am trying to increase a text box field size from 64 characters to 100. I know text fields can hold 255 characters, but whenever I make the change and try to save it, a warning pops up. "Not enough diskspace or memory" Any idea why?

Of course, it works now! Thanks for the help

I have a field in my report its name is PreText and its control source is set to a function, =PreTotal() where Private Function PreTotal() Risk = 0 If Me.PreRisk_minor = -1 Then Risk = 1 If Me.PreRisk_mod = -1 Then Risk = 2 If Me.PreRisk_Serious = -1 Then Risk = 4 If...

Hi Boblarson, your code and method worked well, my query shows just the latest drawings using the Null exclusion trick. Now I want to pass this info off to a printable form. whereTxt = " View_Outgoing_Transmit_pt2.Job_ID=" & jobNumTxt & " AND View_Outgoing_Transmit_pt2.Partner_ID=" &...

Hi Boblarson, I'm thinking of using a SQL string SQLstring = "INSERT INTO Exclude_Table (Drawing_ID) VALUES (" & Number & ")" DoCmd.RunSQL SQLstring before doing this I need to make sure the exlcusion table is clear of all records. Is there an SQL code for doing this??? thanks

Hi Boblarson, thanks for that tip, unfortunately I can't use it as of now since I don't know which drawings to exclude. The script I created goes through my table and finds the latest drawing revisions and then removes (deletes) drawings I don't need. But saying that, I can change my script...

LOL MAJOR FAIL!!!!!:mad::banghead: So the script I wrote works, except it actually deletes the records from my source table. Is there a way to only delete items from a query and not to remove them from the database???

I got it working!!!!:) I needed to add an extra recset.MoveNext. Below is the finsihed code. Rev and Drawing start off as "", then as i step through the recordset I update the values for them so they are always the latest and greatest. I should note that the recordset is ordered by DWGNo...

That may work with some fixing, you see every drawing has its own set of revisions, Drawing 1 may have revisions 0,A,and B where as Drawing 2 may only have revision 0. So the value of Rev will change for everydrawing and I need to make sure I have the highest (latest) version.

I have a record set of drawings (DWGNo) and their revisions (REVNo). I want to create a short list that only contains the latest revisions. I tried "recset.Delete" but I believe that deletes the whole record set. Is there a way to delete the current record. Also, does that move lower records up...

Thanks, totally forgot about that option

is there any way to increase the size of the text field beyond the 255 character limit? I'm creating an incident report and its diffilcult to summarize an accident in less than 255 characters.

I am also having a hard time attaching pdf files to forms. I tried Adobe reader activex control, but I keep getting the error 'Object doesn't support this property or method' Any ideasÉ

make it an attachment and not an image viewer. If you make it an attachment it will open adobe for example to view pdf files.

How do you format your queries to US format or otherway around I have my dates going in as day/month/year but the query results comes out as month/day/year. my SQL is "Select * From View_Report_Job_List Where SaleDate >= #" & Date1 & "#" Date 1 is input from user in format day/month/year

I am having a similar but different problem, it seems access can't tell the difference between a day or a month, unless the value is greater than 12, then it knows its a day. I run a query with this SQL text "Select * From View_Report_Job_List Where SaleDate>= #" & Date1 & "#" where...

what are you stumped on?? Creating a macro?? Just copy the existing macro and change all of the locks to unlocks.

When I try to view the pdf I get this error I believe it doesn't recognize me.PDF.scr I also tried me.PDF.source