Search results

Here it is. I was working on it in Access 2010 to begin with. I took it home and worked on it using my 2007 and it has given me quite a bit of grief since. It starts off as a startup screen. If you click drive around report it will print off a report, so you may ot want to do that. From...

i just went through it. I have it all set up as gstrNew. Its still doing the same thing. Thank you for that though

I do not know what happened it is now telling me also i cannot set my other controls at this time. It was working, then it quit. not sure why

gintNew is a global integer. I have it set up on the startup form. When the user clicks the 'New Record' button, it sets gintNew to 0. It then opens the second for and closes the first. gstrNew = 0 DoCmd.OpenForm "weekly1" Me.SetFocus DoCmd.Close i have the first code i...

I have a startup form that has 5 buttons on it. Each makes a different button on the second visible. I set the gIntNew in the onclick of a button on the first form. I didnt think i would have to open the recordset to add a new record. I tried the docmd.gotorecord,,acnewrec but it gives me an...

the only other code that i have that would effect this is: Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("SELECT * from Weekly") If gintNew = 0 Then 'DoCmd.GoToRecord , , acNewRec cmdAddNew.Visible = True Call cmdAddNew_Click cmdAddNew.Visible = False ' rst.MoveLast...

I am having issues with going to a new record and i do not know why. I am thinking it should be straightforward. I have a startup form with 5 buttons on it. One of them opens up a diferent form and is 'supposed to' open a blank record so the user can enter in their info. It currently goes to...

I do not know if this is possible or how to begin trying to figure it out. I have many controls that do the same function. I have it set up that when they click on a textbox the date automatically populate the control. I then have it so if they click it again, they can delete the date or keep...

I have been trying to find out how to do this for a week now. I know you sent this 8 yrs ago but Thank you. You are awesome

i tried the code you sent. it comes back with a 'expression refers to an object that is closed or doesnt exist' and highlights "CName = ctl.Controls(0).Caption" any suggestions? I am not familiar enough with the controls functions to play around with it

originally i was going to do a mass recordsource rather than change each one manually. I did just end up entering them in manually. Now I am trying to set up a textbox check, to make sure that no blanks were left in the form. I have set this up in the BeforeUpdate of the form. Can i use...

I am wondering what i am able to do with the control after i set it. after i do this: Set cbLocation(i) = Controls("cbolocation" & i), can i access that control now using cbLocation? Can I change anything with that control using cbLocation?

I have a form with many 'like' controls. I have named them cboLocation1, cboLocation2...etc. No rather than set up each individual control (i have 23) i am trying to do it in VBA. I have created a control array to attempt to do this. I tried me.cbLocation(i).ControlSource = "location" & e in...

it does. I have many controls that are very similar do i have named them txtSerial1, txtSerial2, txtSerial3... and so on. I do not know if it can be done but could i run a for/next loop to run through all the similar control names? Something like: for a = 1 to 4 if null(textSerial &...

I have a form that the user must enter in information in all the areas. I have it set up with the following on the first one. Private Sub txtSerial1_Exit(Cancel As Integer) If Len(Me.txtSerial1 & vbNullString) = 0 Then MsgBox "Please enter a serial number" Me.dteDate.SetFocus...

I have not worked with Access in a few yrs. I hope i can explain my issue to make sense. I am creating a database to keep track of Garbage bins we have on site. We have 24 bins. We keep track of 7 things for the bins. Location, Serial number, Size, If covered, product inside (cardboard...

Have worked with Access quite a bit in the past. Havent touched it for almost 4 yrs. Trying to design a database for work. I live in Northern Saskatchewan (Canada).