Search results

Would you be able to post a copy of the database??

I know this might seem like a silly question but.. you never know. If you go back to your original line that worked to open the report without prompts but caused "Error" to be displayed. When you run that macro, is your form open?

You need to have the code in sheet 2, not sheet 1. This way sheet 1 is always visible but sheet 2 will be useless without the password. (See image for location of where to paste code)

Does this fix it??? [Reports]![rptCasenoteEntry]![srptCasenotes].[CaseID]=[Forms]![frmMain]![sformCasenotes].[CaseID]

FORMAT([DateAdded], "HH:MM") Should show just the time

In the query you can use a SELECT TOP n in place of a regular SELECT Would this meet your needs?

Under File --> Save & Publish --> Make ACCDE or Make MDE if your opening a file made in A2003

hmmm.... Private Sub Worksheet_Activate() Dim MYpassword As String Sheets("Sheet1").Select 'here We Move to Sheet1 (Or whatever sheet you want, just change the name) MYpassword = InputBox("EnterPassword") If MYpassword = "123" Then Sheets("Sheet2").Select 'Put the name...

If you go into the VBA and place this code on the sheet you want protected NOT A MACRO it should do what your asking Private Sub Worksheet_Activate() Dim MYpassword As String MYpassword = InputBox("EnterPassword") If MYpassword = "123" Then ' Else...

I agree, I think this would be beneficial to assisting you. (And maybe making some of the concepts a little more clear and understandable)

If my Understanding is correct, You are using a lookup table to duplicate data that should actually be it's own table. your "lookup" table should work like this: (not a true lookup table) "Main table" MainID <= Primary Key Species ID <= Forign key Links to lookup Table Species Table Species...

What field type is ID? is it an autonumber field? If it is, this can't work on a record that hasn't been created yet.

Torrents can be Problematic... as with most Pirate software, it comes with an inherent amount of risk. UTorrent might be worth a look. I know many people who have had good success with that. I can’t say that I’m surprised that LimeWire was shut down. It’s the same story as Napster…. It’s only a...

Thanks for all the help, I tried to add to your reputation, but you help me too much. lol :P

You could put a nice little picture there.....

I used a Subroutine in which i passed the parameters and made the record through a DAO recordset.

Oh, and so far is seems to be working. :) thanks!

Yep, I created a New shell, and imported everything as you suggested. And i'm Compiled my code, I was missing some "dim I as integer" lines. So that was nice to get that cleared up. Is there an advantage to using your Execute SQL statement over my Subroutine that I call and pass too????

Sorry for the delayed resposne, I've been sick. Question With Me.List26 For Each varItm In .ItemsSelected db.Execute "INSERT INTO Link_RentalShoes (RentalID, ShoeID) " & _ "VALUES (" & Me.txtRentalID & ", " & .ItemData(varItm) & ");" '...

The Front End should be relativly easy to follow. Just a couple notes... Start By opening the Main form. Then go to Check availability, Select A date and a return date then click on the "Book 'em Dano" (Hawaii 5-0 reference....) button. It will ask you for a customer name, just be sure to put a...