Search results

Sorry rushed this... going home in a min, just try this: If course_title_combo <> "" Then If MsgBox("You are about to change the course title. You will be required to select a new date also. Are you sure you want to do this?", vbOKCancel, "Correction") = vbYes Then ExitSub Else...

Research Normalization. You can work out what you need in each table using this proceedure, hard to get used to but when u know it, its easy to determine what fields go in which tables. All about redundant data and data dependancies, good luck lol ;)

Could just use it on the form itself. Then txtDate is txtDate on the current form and not somewhere else. If your referencing to another form you would need Forms!FORMNAME!txtDate.

No with this you dont want any temptables involved. That was just something in my code, what my code did (including parts that i didnt copy across) was to get information of items of stock when selected and put that data into temptables to be edited etc. and then when they click TRANSFER they...

If your thinking of doing a reasonable amount of coding in VB or Access/VBA then id suggest buying a VB or VBA book, they very useful. I bought one a few years ago that i still reference to. The internet is good but there is just too much info on the net which can be bad. Unless you work...

Yeah it was just a quick example of a MsgBox call that run off a true or false return value. So ignore some of the code coz it just stuff quickly copy and pasted on here lol :) Yeah vbOKONLY is just an OK button but you want vbOKCANCEL, coz you want the user the opportunity to change the value...

Ok quick example i rumaged up: Dim Course As Recordset Dim StrMultipleCourse As String Set Course = CurrentDb.OpenRecordset("SELECT * FROM Tbl_Course", dbOpenDynaset) StrMultipleCourse = "[CourseName]=" & "'" & txtCourseName & "'" Course.FindFirst StrMultipleCourse If Course.NoMatch Then...

Oh and by the way, id suggest you label your objects better so you dont get confused. Its good practice not to become lazy labelling your objects and you reep the benefits when your programs become more complex. easy way is use 3 letter abbreviations of what they are before what they do...

If MsgBox("You are about to transfer " & [Forms]![Frm_Client]![Frm_RequisitionHeader]![Frm_RequisitionItems]![StockDescription] & " from Requisition " & [Forms]![Frm_Client]![Frm_RequisitionHeader]![FullReqNo] & " OK?", vbOKCancel + vbQuestion, "Transferral Confirmation") = vbOK Then...

One big IF OR statement. IF IsNull(txt1) Or IsNull(txt2)..... Then MsgBox "Not all fields filled in!" etc. Cant really think of another way of checking for blank fields without the IF OR statement.

Yeah there is loads of different types of msgbox's. Just type MsgBox into the Help thing in Access and it'll show you the syntax for them. I'd suggest using the help and MSDN (if you have it) as much as possible to find the answers, they normally pretty good.

Can think of a easy way in the combobox On Change event code: So every time the combo box value is changed it checks the following IF statement: If COMBOBOX <> "" Then MsgBox "You sure you want to update?" Msgbox will all the usual properties as you wish etc. COMBOBOX being the name of your...

Or use the DoCmd.RunSQL line: DoCmd.RunSQL "DELETE * FROM YourTableNameHere"

You might when you created your form selected that the form could not enter design mode from any state. Therefore you will have to enter the .mdb file holding shift which then should solve your problem of not being able to edit the form, as you enter the whole database in design mode. The...

.MoveLast command would do it mate. you'd have to open a recordset and then use a with statement to get there Set BLA = CurrentDb.OpenRecordset("Table") With BLA .MoveLast VariableName = Bal_amt End With With the recordset you could just a SELECT statement and just select the balance field...

Go to the database window that holds all the queries/tables/forms etc, click on the forms tab on the left and then click on New at the top, and then click Design View then OK. A blank form will then open with all the objects etc on a toolbar for you to select and drag onto your form, just like...

Hold shift when double clicking the .mdb file, and it will open the database in design mode.

Ok ill post all the code below including the openexcel function. The only thing i cant paste in is the GetExportDirectory_Excel function call coz it jumps around quite a few functions. But if i were you read up on saving dialog boxes in Access books/VB books/internet etc. This is in my form...

Well then you produce an edit mode. You should create most your forms manually to stop conflicts and so that you know exactly what you are putting on them. Therefore have a form that people can view all records, then an edit button which will then pull that record from the backend so you can...

daherb, make sure that you dont have the input form linked to any tables. Only have it linked on the submition of your "input form". Your input form shouldnt be showing much data, as it is an input form, so all listboxes that you have need to be linked to the corresponding tables which hold...