Search results

Ok that makes sense, thanks! I have a feeling I'll be alright. I think my backend file is ok, I haven't monitored it much but it never seems to be overly large, right now its 1.6mb. I'll be closing monitoring everything, the db hasn't been used yet so I don't know if there will be any issues, at...

I'm embarrassed, I still don't get it. :confused: I do publish the "e" version which gets changed to the "r" version. Since I'm just getting the db in place I expect to replace the front end at least once a week but in a couple months I'm hoping I don't need to work on it and can take a break...

Not really sure what that means but I'm guessing its all good. :D Lightwave I am using the runtime for the frontend, first I make executable then I use the package solution to make the installer, however one feature I added only works if the full version is installed, but it will work in the...

Oh one other thing I have a question about, compact and repair? I know its important to run compact and repair regularly and I have right from the get go. Every couple hours while working on it I would close it down so it could compact. In the frontend db options I have the "compact on close"...

More good comments, thanks! I have a feeling my cascade updates are doing nothing and one day soon I will remove them, as for deletions there are none happening through-out the db unless its a simple record that's meaningless, all the records that have a cascade delete won't be getting deleted...

Thanks Pat, I enforced the remaining relationships there were actually 4 in there and everything seems ok. That's just making things proper, right? Could that have any affect on network speed? Thanks PNGBill for the tips, when I was building this I wanted to setup a small network at home to...

Thanks for explaining that to me, based on your comments I think I'm ok. Before I started I did try to get every right with relationships but because I know nothing about access I could only do what I could. All but a couple of my relationships have the enforce RI checked, at this point I'm...

I can't find the subdatasheets settings, where would I look? The frontend file does run off the local machine, only backends on server.

Thanks, I did that when I started building, read it somewhere along the line.

Hi, thanks I have merged the files into 1 however I'm not sure what you mean by "enforce RI"?

Hi, I've been working the last 10 months on a database and now its time to put it to the ultimate test, real life. I also want to thank those that helped me with some issues along the way! The database is quite large, has about 700 objects and about 35 of those are tables. What I did was split...

Thank-you the .recordcount works great

Hi, I want to make an IF statement that says the following If Me.OrdersOrdersSubform.Form.RecordSet = more than 1 record Then Do something Else Do something else End IfThanks

Well, I'm happy I figured it out. Not the cleanest solution but its what I came up with and it works. Since my original code did work and just didn't do all the records I thought about playing with GoToRecord and SetFocus. Now I have it so the 2nd subform setsfocus and goes to first record...

Hi, I have a bit of an issue with SQL Update / Insert. I have a form that runs an SQL insert when a field is popluated and it works fine. When this sql insert runs it can add anywhere from 1 new record to 50 new records depending whats on the form. DoCmd.RunSQL "INSERT INTO Inventory...

The right criteria could be tough, subform1 and subform2 share ProductID, Subform1 shares OrderID with OrderSubform but subform2 has no OrderID and can't because it comes from a different source all together. Subform1 always gets propulated first and those are the records I need to update. Next...

Perfect, thank-you! I tried so many combinations too. I have a subform2 set as continuous with multiple records, there's another subform1 setup the same way and shows the same records. These records share a productID. I need all records on the subform1 to update but at present its only using...

Hi, I'm trying to get an SQL update to work with 2 criteria's however I can only get one of them working at any given time, any ideas? This code works fine and finds the correct product. DoCmd.RunSQL "UPDATE Inventory SET BarsGiven=" &...

Thanks for the suggestion but its been solved, someone figured it out for me. This is the code I put in the "OnLoad" event of the subform. Dim rs As DAO.Recordset Set rs = Me.RecordsetClone While Not rs.EOF DoCmd.SetWarnings False DoCmd.RunSQL "UPDATE Inventory SET BarsSold=" &...

Hi, I've got a bit of an issue with a calculated textbox on a form. Everything is working on the form fine and the calculation does work if a user enters a number in another textbox but what I want to happen is when the form opens the textbox does its calculation based on the values in the other...