Search results

Hey Everyone, Quick question i have an access form fully functional works every time, however in some cases there are slight delays, for example even though the loading sign i display turns visible=false after a recent button click, i later access a different button, but this leads to an...

Thank you Assigning AB and a # solved the issue.

As i mention above it's an error when "im trying to insert a new line" Selection.EntireRow.Insert Shift:=xlDownI have other lines of code accessing the Excel file change the background color and re-size the columns, this works perfectly and i verified the trust/securities setting prior to...

The code is placed in a Access 2007 Application, ive already attempted to record a macro from Excel and insert it into Access, however this does now work. i Still receive the error issues in access error 1004.

Hey everyone thanks for your help in advance, im trying to insert a new line below the active cell ive tried several attempts but i am getting error 1004. Some attempts are commented out. wks6.Activate With wks6 .Select...

If you can i am trying to inset a new line right after the insert is done , Range("AB").Offset(1).EntireRow.Insert however this crashes do you know why ? Error 1004 ive also tired .Range("AB").EntireRow.Offset(1, 0).Insert

Amazing it worked thanks for such a fast reply.

thank you in advance for taking your time to help me out, I currently have a loop running which selects a range, copies and then pastes the values in the required columns. Set wks6 = wkb.Sheets.Add With wks6 Dim rstCP As Recordset...

Hey guys ive been looking online and seeing a lot of comments about cascading deletes, Relationships and enforcing referential Integrity. However i still cannot find my error where i have went wrong, hopefully someone out there is quicker than me, by the way im new in Access. So here is a...

I think it should use GroupBy and aggregate functions to do the following steps I require, however I just can’t get this to work: So say I have the table below but with more records Price Cost Zone Zip Code Weight(lbs) Price Cost Freight Value 5 K0K...

Hey people, Ive been trying too serach stuff on the net but got no solution, hopefully i can get help from your guys, my issue is i have a main report which contains multiple sub reports which are dvided by bage breaks, then within each subreport i have a page break in one of the footers. Now...

I have to two different forms, however i have a foreign key in one of my other forms however the data doesn't seem to be automatically linked to it. When i created the two forms into one they are linked however, so my question is how can i do the same but in two separate forms ???

Your right my criteria is wrong i am not producing any results from it, how can i fix this ?

i have a uniqueZip table which has a set of unique rows with a certain code, now my goal is to update the Route tbl to have the match code by comparing the rows from one table to the other. This is my sql statement however this does not change any rows even though there is matching data. Can...

hold i'll try to rephrase this my table and its data below i have tones of records like this so there are many duplicate data for fields [data 1], [data2] and [data 3] Zip | Data 1 | Data 2 | Data 3 | Code | 123 | __A__ |__...

I have a table with five fields, | Zip code | Data 1 | Data 2 | Data 3 | Code | The Data 1, 2, and 3 can have duplicates, so my goal is to gather all three fields and find the unique rows and assign a code to them, therefore they can reflect it to all the...

Thanks for the help guys!

=[Forms]![Route Form]![ CreatorDD]+"_"+[Forms]![Route Form]![OriginDD]+"_"+[DAYS OF]+"_"+[SERVICE TYPE]+"_"+[EXTRA DAYS]+"EX"" From the code above every time I have nothing in the field [EXTRA TRANSIT DAYS] this string is not printed out, I want to place like a if statement in here as so If...

I want to create a form with a checkbox option where the user can select either a 12 or 24 time format, followed by an listbox option where they will then select a time interval either an 30 min or hour up to 12 (ex 30 min interval 9:00am - 9:30 am - 10:00am and so on), followed by inputbox...